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

[gurucharanscm]

Hi Austin - So, what you are looking for here? The logic is pretty straight forward, so would want to understand what is the challenge?

Thanks,

Regards - Guru

[Former Member]

Hello. So when making this marco, I am confused with the steps that I need to build it. How can I create an If statement for he logic above just using marcobuilder?

If there is no corrected history then replace it with raw history else maintain corrected history if there is corrected history.