Flagging Non zero , number formatted line item

MadhabikaM

Hi All,

I have a number formatted line item, i want to flag this field in another text formatted line item.

saying its " error in value" else " No error", based on blank or non blank of first line item.

Regards

Madhu

Accepted answers

hari.prasad

(Only if required) Use TEXT() function to convert number to text in your formula, to validate your required condition

Otherwise, I agree with Bram & Niranth.

All comments

Niranth

Hi @MadhabikaM ,

You can use the formula "<> 0" and achieve your results.

hari.prasad

(Only if required) Use TEXT() function to convert number to text in your formula, to validate your required condition

Otherwise, I agree with Bram & Niranth.

bram.kurstjens

Hi Madhu,

Number formatted line items cannot be blank. They always have an integer as value. If 0 is an 'incorrect' integer in your case, then indeed the answer of Niranth IF ... = 0 THEN "Error in Value" ELSE "No Error" is correct

Niranth

Hi @hari.prasad

There is no requirement to convert the values into text, You can directly refer the 'number formatted line item' and use the condition =(equal) or <> (not equal).

I'm suggesting this because converting numbers to text will all another additional layer of calculation and is not best practice.

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…