Making If statements for Macrobuilder

[Former Member]

CURRENT MONTH LOAD

** If there is no corrected history (null value), then pull raw history value

** If there is a correct history value, then maintain corrected history value

* PREVIOUS MONTHS (>1-MONTH HISTORICAL) UPDATE

** If raw value does NOT equal corrected history value, then maintain corrected history value

[gurucharanscm · Accepted solution]

Hi Austin - Please consider below synonym in the drafted macro. Also, I have used an auxiliary key-figure for result as you didn't specify anything, you may choose to have a data view key-figure for 'Result'.

Corrected History = Additional Key Figure 1

Raw History = Additional Key Figure 2

Hope this helps, please upvote if so 😉

Thanks,

Regards - Guru