SumIF To Set Analysis Help

[gauthamchilled]

Hi,

Need a help in converting a sumif to set analysis. Below is the expression.

=sum(if([Trans Date] <= $(vAgeDate)
and $(vAgeDate) -[$(vBasis)] > vAge2
,[Sales]
))

where
Trans date is transactiondate
vAgeDate is AgeDate
vBasis is InvoiceDae
Vage2= 90

Can any body help?

[gauthamchilled]

bump

[tresB]

I assume, AgeDate and InvoiceDate are field. If so, I don't get how are they different from the variables. Are you using any aggregation function in the variable definitions? Could you explain with a sample ?

[gauthamchilled]

Hi,

vAgeDate is max(AgeDate) but vBasis is just InvoiceDate field

[tresB]

InvoiceDate has multiple dates? Are you expecting to select a single value from this field before an output comes?