formula

I have the problem .. i have a list on left and i have the formula like the picture .. half the list using formula and half again using formula but null value . how work for the problem?

Accepted answers

DavidSmith

You cant have a blank OR zero in Anaplan. There is no concept of Null. A number cannot be blank. So I’ll take a guess
IF line item 1 = 0 THEN 0 ELSE line item 2 - line item 1
If line item 1 is not often zero you should write it the other way around
IF line item 1 <> 0 THEN line item 2 - line item 1 ELSE 0
You should put the most common expression first.
Hope that helps.
David

All comments

SathyaM

Hi @adisulyadi,

Do you have a module with the list (as mentioned in your screenshot)? If so, can you please share the screenshot of your module for better understanding.

Thanks

Sathya

Aishwarya

Hi @adisulyadi ,

In your screenshot, column 'I' is cropped. Can you please include that column also in your screenshot for us to understand what exactly is your requirement.

Thanks and regards,

Aishwarya

DavidSmith

Aishwarya

@DavidSmith Adding to your idea , I think if they need a blank cell there for values=0 , they can choose 'blank' from 'Zero values' drop down while choosing the number format for that line item.

blank_for_zeroes_44246.JPG

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
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…