function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AbAb 

Report | If statement | false value never displayed

Hello,

I use below formula in report for display of currency.
I am never sucessful to display 8 or any value in the field 
IF(ISBLANK(AMOUNT:SUM), 8, AMOUNT:SUM)

Thank you
Best Answer chosen by Ab
Asha KAsha K
Instead use IF((AMOUNT:SUM == 0) , 8, AMOUNT:SUM) it will work 

All Answers

Asha KAsha K
Instead use IF((AMOUNT:SUM == 0) , 8, AMOUNT:SUM) it will work 
This was selected as the best answer
AbAb
It didnt work,

I also tried, IF((AMOUNT:SUM < 1) , 8, AMOUNT:SUM) 
This alos doenst work too
Asha KAsha K

IF((AMOUNT:SUM == 0) , 8, AMOUNT:SUM),It definetly works. After adding the formula , save the report and run the report you will be observing the formula field you added in the summary report .I just npw tried it worked for me
 
AbAb
Well, this is not working for me
Asha KAsha K
Please let me know the steps you performed after adding the formula field.Here is the screenhsot as well 


Formula