Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I need some help to build a setattribute with sub-setattribute.
My model is simple.
doc:
Customer,
Year,
YearAgo ( load from year(Today() - Year)
Sales;
I'll found my 're-born' Customer; the one who have Sales on YearAgo=0 and without Sales on Yeargo=1
Here is my formula
Sum({$<YearsAgo={0}, Customer={" =Sum({$<YearsAgo={1}>} Sales)={0}" } > } Sales)
but I get 0.00 ... sure there is some.
What's wrong on the syntax?
Thanks for any help.
Manu
Try this
Sum({$<YearAgo = {0}, Customer = e({<Customer = {"=Sum({$<YearAgo = {1}>} Sales) > 0"}>})>} Sales)
or this
Sum({$<YearAgo = {0}, Customer = e({$<YearAgo = {1}>})>} Sales)
Try this
Sum({$<YearsAgo = {0}, Customer = {"=Sum({$<YearsAgo = {1}>} Sales) = 0"}>} Sales)
sorry, it did'nt work....
doc:
load
Customer,
Year,
year(today()) - Year as YearAgo,
Sales
inline [
Customer,Year,Sales
a,2018,200
a,2017,200
b,2018,300
c,2017,100
];
Try this
Sum({$<YearAgo = {0}, Customer = e({<Customer = {"=Sum({$<YearAgo = {1}>} Sales) > 0"}>})>} Sales)
or this
Sum({$<YearAgo = {0}, Customer = e({$<YearAgo = {1}>})>} Sales)
I got it !
You can't select what is does'nt exist...
I must 'exclude' what's exist....
thank you for your help.
You got it