set analysis error

[#1]

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

[Oleg_Troyansky]

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

[#3]

Thanks for advice, but it seems to have issues addition to that.

[Oleg_Troyansky]

can you provide any specifics? Or, even better, post an example?

[#5]

I am still having syntax errors.

[#6]

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

[Oleg_Troyansky · Accepted solution]

See attached. A couple of brackets were missing. The working formula is:

sum( {<Year={"$(=max(Year))"},Customer=p({<Year={"$(=max(Year)-1)"}>})>} Sales)

cheers!

[#8]

Thanks!