how to write a script for last 30 days value(variable)

[jim_chan]

Hi guys,

I have created a variable. wanted to use it with the belwo last 30 days expression. i coudlnt get any value, iwhat is wrong with the expression??

=Sum( If( AddMonths(Today(),-1) ,$(vAmount1)))

Rgds

Jim

[sunny_talwar]

Can you show how you define vAmount1 variable?

[kaushiknsolanki]

Hi Jim,

So you mean you want them amount from last 30 days.

Then you should use.

Sum({<Date = {">=$(=Addmonths(Max(Date),-1))"}>}Amount)

If not then please give some example to understand your issue.

Regards,

Kaushik Solanki

[jim_chan]

is very long expression in it.

Sum (If (A_Funds = 'FUNDS_IN', local_amt))

+ Sum(If (B_Funds = 'FUNDS_IN', cust_local_amt))

+ Sum(If (C_funds = 'FUNDS_IN', payout))

-

(Sum (If (A_Funds = 'FUNDS_OUT', local_amt))

+ Sum (If (B_funds = 'FUNDS_OUT', ttl_payout))

+ Sum (If (C = 'FUNDS_OUT'  and claim_com_code <> 'CHY', claim_local_amt)))

- sum(session_actual_winner)

[sunny_talwar]

So I guess you are trying to do aggregation within aggregation which would require you to use Aggr() function.

[jim_chan]

is too long to add in that expression into this:

Sum({<Date = {">=$(=Addmonths(Max(Date),-1))"}>}Amount)

[sunny_talwar]

Would you be able to share a sample?