How to replace no value to zero. If there is no record in backend
Group Name Profit
A Dave 10
A Julie 20
A Peter 30
B Dave 40
B Peter 22
C Julie 11
Here, in this Group B name Julie data not avaialble and for group C name Peter and Dave data not avaiale.If we want to show all name and group combination of data then missing data will come blank.
Ifnull and ZN function wont work as in data its not NULL.
Solution:
if not ISNULL(LOOKUP(SUM([field]),0)) then 0 ELSE
sum([field])END
