What is the purpose of ,sales = {'*'}>} ?

[paulyeo11]

Hi All

I notice that below both expression return sames result :-

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} sales)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000)

May i know what is the advantage of sales = {'*'}>} ?

Paul

[paulyeo11]

Hi Sunny

i have remove mar sales value from raw data , and when user select current month = 3 , i expect it should display jan till mar sales amount ( in this case it will should display jan till feb value , since march sales amount = 0 ), but now it display zero which i think is not correct.

Paul

[vikasmahajan]

this is actually right answer  Paul

Vikas

[Anonymous]

Kushal,

Check your sum({<status={'*'}>}Sales) will return 300 instead 600 because for ID 3 status value is NULL.

I think if you give  um({<status={'*'}>}Sales) ut return total 600 not ignore Status-->null value--> sales.