Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data like attachment,
I have null sales value for month of Sep, because of some requirement i have taken that table as resident with group by.
But whenever i am showing this data on sheet level in table format then this null values gets replaced with "0".
I want to show that null value as "-".
Regards,
Villyee
May be as below:
Try from presentation tab
try in script,
NULLASVALUE SaleMonth;
SET NullValue = '- ';
Try this script:
Test:
Load * inline [
Date,SaleMonth,SaleYear,Sales
01/23/2014,Jan,2014,20
11/11/2014,Nov,2014,0
12/24/2015,Dec,2015,50
09/19/2015,Sep,2015,
];
Final:
NoConcatenate
LOAD If(Avg(Sales) >= 0, Sum(Sales)) as Sales,
Date,
SaleMonth,
SaleYear
Resident Test
Group By Date, SaleMonth, SaleYear;
Drop Table Test;
UPDATE: Forgot to acknowledge, but I used the sample provided by Thirumala and made some modifications to it