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.

Accepted answers

All comments

DavidSmith

@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

robinsalk

Hi David,

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

DavidSmith

@robinsalk

That would be the original line item as per the attached

I hope that clears it up

David

robinsalk

It does.

Thank you David.

Misbah

@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

robinsalk

Thank you

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…