Ability to add absolute values across months

Occasional Contributor

Ability to add absolute values across months

I have a client who would like to create a new period in Anaplan that sums the absolute values of the months.
This will help in identifying account combinations with 0 across all the versions in the model. Is there a way to add formula periods?

AbsFY=abs(jan)+abs(feb)...abs(dec)

If not, how can they add it to a module? for example, they'd like to be able to select AbsFY in time and see across versions where accounts have no data.

Message 1 of 7
6 REPLIES 6
Community Boss

Re: Ability to add absolute values across months

@robinsalk 

A better way would be to add a second line item

line item2= ABS(line item1) and then total it up

You can then use TIMESUM(line item2) to pull it into a module without time

 

I hope that helps

David

Message 2 of 7
Occasional Contributor

Re: Ability to add absolute values across months

Hi David,

Thank you for the quick response. One question regarding your example. What would be line item 1?

 

Message 3 of 7
Community Boss

Re: Ability to add absolute values across months

@robinsalk 

That would be the original line item as per the attached

2019-09-20_09-15-28.png

 

2019-09-20_09-16-55.png

 I hope that clears it up

David

Message 4 of 7
Occasional Contributor

Re: Ability to add absolute values across months

It does.

 

Thank you David.

Message 5 of 7
Frequent Contributor

Re: Ability to add absolute values across months

@robinsalk 

 

Step 1: Create Line Item 1 - Time Dimension

                Formula - ABS(Source Line Item)

Step 2: Create Line item 2 - Probably in another module with no Time Dimension

                Formula - TIMESUM(Line Item 1) - Make sure 

Step 3: Filter on Zeros - You will be able to see all the Accounts with No Transactions

 

Thanks,

Misbah

Message 6 of 7
Occasional Contributor

Re: Ability to add absolute values across months

Thank you

Message 7 of 7