TIMESUM Formula - 1.5.7.1 SYS13 Account SKU Filter Module

BernardoSiv · 2024-03-21T12:31:21+00:00

There was an error rendering this rich post.

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

Results seems correct

Data03 Historic Volumes module

Blueprint view

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 ?

Accepted answers

1636583

Hello @BernardoSiv

Maybe check the module naming's, those are created as guided in the story?

All comments

PujithaB

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

1636583

Hello @BernardoSiv

Maybe check the module naming's, those are created as guided in the story?

BernardoSiv

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

BernardoSiv

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

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!

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…