Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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
Try First Portion and let me know whether it's working or not...
=count({<%date={">=$(=date(max(%date)-15))<=$(=date(max(%date)))"}>} nomenclature)
work
Now Check below by creating a Straight Table
Dimension
nomenclature
Expression
=IF(sum({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"}cost)>0,1,0)
work.
Is it possible to upload sample apps or sample data file?
No. It on server of another company... only screens and code
Can't you create dummy data in excel file (Only 10-15 lines)