TIMESUM Formula - 1.5.7.1 SYS13 Account SKU Filter Module 

Options
BernardoSiv
BernardoSiv
edited March 21 in Academy Discussions

this is my formula: IF TIMESUM('DAT03 Historic Volumes'.Volume) <> 0 THEN TRUE ELSE FALSE it does seem to work but when I copy paste in the exam it says incorrect.

1.5.7.1 Create SYS13 Account SKU Filter Module 

My formula

Screenshot 2024-03-21 at 12.36.34.png

Results seems correct

Screenshot 2024-03-21 at 12.37.50.png

Data03 Historic Volumes module

Screenshot 2024-03-21 at 13.28.46.png

Blueprint view

Screenshot 2024-03-21 at 13.29.12.png

However when I copy paste the formula into exam it is wrong

this is my formula: IF TIMESUM('DAT03 Historic Volumes'.Volume) <> 0 THEN TRUE ELSE FALSE

Anyone has clue ?

Best Answer

Answers

  • PujithaB
    PujithaB
    Options

    Hi @BernardoSiv
    Is it incorrect or throws an error
    If it is incorrect, Check the Time sum Function Parameters here
    https://help.anaplan.com/timesum-45c3bc48-4d80-490d-9b18-76af505c6907
    It throws error Whenever you copy pasted it will throw error if you have any naming differences of Volume line item

  • BernardoSiv
    BernardoSiv
    Options

    The formula seems to work in the module. But my fomula is not accepted in the exam (Level2 Sprint1).

  • BernardoSiv
    BernardoSiv
    Options

    Solved: The formula logic is correct however there was typo in the line item wording 'Volume" instead of "Volume". That is why when I copy paste the formula in the exam it did not recognized it.

    Thanks everyone!

  • Dikshant
    Dikshant
    Options

    Ideally, I would not write IF ELSE around TIMESUM and simply put TIMESUM('DAT03 Historic Volumes'.Volume) <> 0 😉 But level 2 will expect you to surround it with IF ELSE.

    You won't believe the mistake here. I guess the line item name has to be Volumes in DAT03 Module 🙂

    IF TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 THEN TRUE ELSE FALSE

    Try this!

Categories