Group By Issue in Null Field

[vanderson009]

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

[trdandamudi]

May be as below:

[Anil_Babu_Samineni]

Try from presentation tab

[Chanty4u]

try in script,

NULLASVALUE SaleMonth;

SET NullValue = '- ';

[sunny_talwar]

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