Hi,
Can I please get some help with the formula for this?
Thanks
1)The formula should check the total of all product SKU volumes over all time periods
2) check if the value is not equal to zero.
1) You need to use Timesum() function to sum Product SKU volumes over all time periods, Review timesum() function : https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/TIMESUM.html
2) and the result you achieved using that function need to compare using a conditional operator to set boolean value true.
Review conditional operator:
https://help.anaplan.com/anapedia/Content/Calculation_Functions/Operators.html
Can you share your formula? thanks
Hi, can anybody please help with this query?What formula is to be used?
Okay how did we get here?
Reviewing the TIMESUM syntax, the example is:
TIMESUM(TIMESUM line items.Number, 0, 4, SUM)
so my latest try was: TIMESUM(TIMESUM Has Data?, -1, 0, SUM)
which I thought would take data from each line which has a data in the Has Data? Boolean, from the last period (-1) to the current period (0) and sum it.
This suggestion
IF TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 THEN TRUE ELSE FALSE
which works, doesn't seem to fit the syntax to me at all; how does it work?
Also why are we referencing DAT03? Isn't this a filter to be applied?
Hi @jadefortunato
Both syntax are correct.
In first you are asking anaplan to sum up the values across the time period of the module and then to check where the sum is not equals to zero.
TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0
In below syntax you are using three more arguments(start period,end period and aggregation method) along with Number line items. In current scenario it is not required to have these 3 arguments.
Thanks for this... I also asked in class today and Anees disambiguated this a little bit:
The TIMESUM function ends after the parentheses: TIMESUM('DAT03 Historic Volumes'.Volumes)
The boolean operators <> and value 0 are an IF statement separate from TIMESUM
The final portion is unnecessary as it is the default way Anaplan interprets <>0
So the most elegant solution would be:
TIMESUM('DAT03 Historic Volumes'.Volumes) <>0
Thanks to all!
TIMESUM('DAT03 Historic Volumes'.Volumes) <>0 this formula is not working for me can someone help me.
TIMESUM('DAT03 Historic Volumes'.Volumes) <>0 is still not working for me - can someone help?
The timesum function mentioned by vishwajeetg & @swapnil_J are correct, (you can skip the if-statment when working with booleans if the if-statment only contains one level (and not multiple nested if-statments) e.g. "if X then Y else Z") The issue I think most of you coming to this part of the forum have is that your dimensions missmatch. Please observe the following in your model. You have two sets of lists both Flat and Hierarchy-structured lists. Make sure that if you have flat list in the DAT03 source, that you use these lists in the Timesum module as well.
True!
It definitely was a dimension mismatch for SKU… :-)
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (not…
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
