Set in set

[#1]

Hi all! not work set with set.

count({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"},

nomenclature={"=sum({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"}residue)>=vAvgOst"},

nomenclature={"=sum({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"}cost)>0"}>}

nomenclature)

where vMaxDateSale=41638

write error

[#2]

=count({1<%date={">=$(=date(max(%date)-15))<=$(=date(max(%date)))"},

nomenclature={"=sum({1<%date={">=$(=date(max(%date)-15))<=$(=date(max(%date)))"}>}cost)>0"}

>} nomenclature)

new....but not work

[MK_QSL]

Try First Portion and let me know whether it's working or not...

=count({<%date={">=$(=date(max(%date)-15))<=$(=date(max(%date)))"}>} nomenclature)

[#4]

work

[MK_QSL]

Now Check below by creating  a Straight Table

Dimension

nomenclature

Expression

=IF(sum({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"}cost)>0,1,0)

[#6]

work.

[MK_QSL]

Is it possible to upload sample apps or sample data file?

[#8]

No. It on server of another company... only screens and code

[MK_QSL]

Can't you create dummy data in excel file (Only 10-15 lines)