Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears
I have table that sometime some fields get NULL Value.
I want that NULL values change to zero and my chart doesn't get Error like following pic.
I have tried IsNull Function but didn't work,
would you please help me?
Dimension: DATE
Expression: =if(IsNull(sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}TotalDownload))=0,0,sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}TotalDownload))
Use the function ALT it can replace any NULL value with 0 (zero):
ALT(sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}TotalDownload),0)
Isnull function gives -1 if there is null value otherwise 0.
Refer the help page.