Forum Discussion
Show Blanks as Zero values
Hi Experts
i am sure this question has been asked a thousand time.... but cannot get this formula to show the blank cells as Zero..
Fees =
CALCULATE (
SUM(Data[ApplesFee]),
FILTER (Data,Data[Apples]="true"))
Just add a +0 to your formula:
That should do the trick
SUM(Data[ApplesFee])+0,
2 Replies
Just add a +0 to your formula:
That should do the trick
SUM(Data[ApplesFee])+0,