if to set analysis

[#1]

Is there a way to convert this to set analysis?

if((ADate-90<=BDate), aggr(max(total <KEY> FieldC),KEY),0)

[#2]

Hi,

Try something like this:

aggr(max({$<BDate = {'>= ADate-90'}>} total <KEY> FieldC), KEY)

[#3]

Hi there,

it should be something like this:

aggr(max({$<BDate={'>=$(ADate)-90'}>} total <KEY> FieldC),KEY)

Hope this helps

Regards!

[#4]

what if I change it to

sum(if(ADate-90<=BDate), aggr(max(total <KEY> FieldC),KEY),0)

Would i put the set after sum, aggr, or max?

[#5]

Oh I also have a variable which i have been using after the sum as $(variable)

thanks!!

[#6]

You have to put the set analysis inside sum and max.

can you give an example of how you use your variable?

[#7]

sum($(variable)aggr(max({$<BDate={'>=$(ADate)-90'}>} total <KEY> FieldC),KEY)

Here is my current expression, but if I change the 90 to 60 or 30 it does not do anything to the numbers I am getting. Is that due to my expression or most likely something else?

[#8]

I haven't prove it, but try:

sum($(variable) aggr(max({$<BDate={">=$(#=date(ADate-90)"}>} total <KEY> FieldC),KEY)

What is the value of the variable?