Null values in set analysis

[#1]

Hi all,

I'm looking for null handling in set analysis.

I have gone through many threads though, couldn't find an appropriate solution.

Here is what i'm looking for.

sum({<[Month]={'<=$(=max([Month]))'}>}[SALES])

This will do an YTD calculation. But for some months i have sales value as null (). so i dont see any accumulated sales value for that country.

I tried something like below already, that's not working out.

sum({<[SALES]={*},[Month]={'<=$(=max([Month]))'}>}[SALES])

Thanks in advance.

[MK_QSL]

Can you provide sample data please?

[#3]

try "show zero" in presentation tab

[#4]

Try,

   In Presentation tab,

  1. Uncheck 'Suppress zero-Values'

  2.Check-In 'Zero On-bars'

Regards

Lathaa

[sunny_talwar]

This might help:

Sum({<[SALES]={'*?'},[Month]={'<=$(=max([Month]))'}>}[SALES])

I have found out that only * doesn't seem to remove null, but '*?' does. Give it a try, may be it solves your issue.

HTH

Best,

S

[#6]

Hi

  My suggestion is remove the null's in script level only that will be best practices

load

*

resident Table1 where sales>=0;

try this

thanks

Manju