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
(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.
Hi @MadhabikaM ,
You can use the formula "<> 0" and achieve your results.
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.
Is there any way to have the last item of the waterfall be a running total that starts from 0 and shows the net of the previous waterfall components? I'm using line items here, would just want the Ending NAV to always start at 0
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
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…
