Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I need help on indirect set analysis. I am currently using v9
[ code ]sum(<Year={"$(=max(Year))"}>,Customer=p({<Year={"$(=max(Year)-1)">}})Sales)/code ]
it should return this year's sales for customers who had sales last year, but I am having syntax error!
Thanks for help
Ryan
See attached. A couple of brackets were missing. The working formula is:
sum( {<Year={"$(=max(Year))"},Customer=p({<Year={"$(=max(Year)-1)"}>})>} Sales)
cheers!
As much as I can see, you have the two brackets switched places. Try this:
[ code ]
sum(<Year={"$(=max(Year))"}>,Customer=p({<Year={"$(=max(Year)-1)"}>})Sales)
[/code ]
Oleg
Thanks for advice, but it seems to have issues addition to that.
can you provide any specifics? Or, even better, post an example?
I am still having syntax errors.
Here is an example file that I actually got from QDays! I am trying to understand the code before I implement indirect set analysis to my project, but example has sytax error
See attached. A couple of brackets were missing. The working formula is:
sum( {<Year={"$(=max(Year))"},Customer=p({<Year={"$(=max(Year)-1)"}>})>} Sales)
cheers!
Thanks!