How to replace null values (represented by "---") in a cross table with some meaningful keywords like NA if string or 0 in case of real or integer data type columns used ?

An output sum of rows on data table is null as in source file there was no entry of that particular item.
Thus, the results showing for dashboard as '---' . NOW we want to replace this ( blank/empty) to either NO or Yes. Please advice me. 
I am using below expression but its not working:
case  when Sum([Quantity])>0 then "Yes" when (Sum([Quantity])<=0) or (Sum([Quantity]) is Null) then "No" end as [Penetration]
Thanks in advance !!

Attachments

AttachmentSize
Binary Data book1.dxp43.37 KB

2 Comments

Check out the SN() function... replaces null values in a column with whatever you specify.
Cheyne Harvey - Mar 30, 2016 - 10:44am ::
Attached is sample .dxp file for reference
abhishek.parash... - Jan 08, 2016 - 6:09am ::
+ Add a Comment

(5) Answers

Login