Hi,
我希望有人可以帮助解释/步行我刺ough 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 ofCurrent 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.
