10-16-2018 5:59 AM - edited 02-04-2024 4:02 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
11 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.