TIMESUM syntax error

Hi everyone !

I am currently doing the Level 2 Model Builder, Sprint 1, and I am stuck at step 1.5.7

Basically, I need to feed a boolean Line Item called "Has Data?", which is on the SKU ; Account dimensions from a numeric Line Item called Volumes, which is on SKU ; Account ; FY19 dimension. Therefore, I need to aggregate the data on the time dimension, using a ANY aggregation method to retrieve a boolean value.

Here is how I try to feed "Has Data?":

TIMESUM('DAT03 Historic Volumes'.Volumes , , ,ANY)

TIMESUM('DAT03 Historic Volumes'.Volumes, From, To, ANY)

and even

TIMESUM('DAT03 Historic Volumes'.Volumes [,] [,] [,ANY])

None of these worked, I'm stuck...

Here is what I found on Anapedia :

TIMESUM(Line item to aggregate [, Start period] [, End period] [, Aggregation method])

Start Period & End Period are non mandatory values according to Anapedia. However, missing intermediate parameters are not permitted. I'm not sure what's that suppose to mean...

Thanks in advance for your kind help !

Benoît

Accepted answers

AdamCookson

Hi,

If I remember correctly you should just be able to use Timesum('DAT03 Historic Volumes'.Volumes) without any further values and meet the 'Has Data?' flag requirements. Effectively this will just remove the time dimension from the original value and flag the true/false per account for you.

Hope this helps!

Kind Regards

Adam

All comments

AdamCookson

Hi,

Hope this helps!

Kind Regards

Adam

filip.sypniewski

Hi @Benoit_Martin,

you can skip any optional arguments in the syntax and simply use TIMESUM(Line item to aggregate)

Benoit_Martin

Thanks @Adam !

Here is the formula I used :

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

It works just fine.

benkoz75

I'm sorry but we can't skip arguments in the syntax and simply use because this is not number format it's boolean and formula needs if then else arguments.

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

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…