Driver formula help

Walker32

Hi, 

 

I am hoping someone can help explain / walk me through what this driver formula is doing. 

 

IF

    Driver Method <> 'SYS002 - Model Lookups'.'Flat to PY - 70% Owned Sales'

THEN

    0

ELSE

    LAG('Total Output ($) [Staging]', 12, 0) * 0.3 + LAG('Total Output ($) [Staging]', 12, 0) * 0.7 * 'DAT002 - Sales Data'.Owned Sales / ('DAT002 - Sales Data'.Owned Sales - LAG('DAT002 - Sales Data'.Owned Sales, 12, 0))

 

My thought process:

-  Taking prior years month (may-21) and multiplying by .3

LAG('Total Output ($) [Staging]', 12, 0) * 0.3 + LAG('Total Output ($) [Staging]', 12, 0) * 0.7 * 'DAT002 - Sales Data'.Owned Sales / ('DAT002 - Sales Data'.Owned Sales - LAG('DAT002 - Sales Data'.Owned Sales, 12, 0))

 

- adding the value of prior years month (may-21) multiplied by .7 multiplied by Current month's total owned sales 

LAG('Total Output ($) [Staging]', 12, 0) * 0.3 + LAG('Total Output ($) [Staging]', 12, 0) * 0.7 * 'DAT002 - Sales Data'.Owned Sales / ('DAT002 - Sales Data'.Owned Sales - LAG('DAT002 - Sales Data'.Owned Sales, 12, 0))

 

- dividing by the difference of Current month's total owned sales (may22) and Prior month's (May21) total owned sales.

LAG('Total Output ($) [Staging]', 12, 0) * 0.3 + LAG('Total Output ($) [Staging]', 12, 0) * 0.7 * 'DAT002 - Sales Data'.Owned Sales / ('DAT002 - Sales Data'.Owned Sales - LAG('DAT002 - Sales Data'.Owned Sales, 12, 0))

 

However I am not getting the same value that the model is showing (associated ROF). Attached screenshot for reference.

 

Please let me know what I am missing here.

Walker32

Thank you! I see where I tripped up..order of operations.