error in expression

[master_student]

Hello Guys,

I have en error in my expression bellow :

=num(sum( {$<[Year of date]={$(=Max([Year of date])-1)},[Calendar date]={"<$(=Date(AddYear(Today(),-1))"}>} recharge_amount),'# ##0')

[Colin-Albert]

There is a missing bracket

=num(sum( {$<[Year of date]={$(=Max([Year of date])-1) }, [Calendar date]={"<$(=Date(AddYear(Today(),-1)) ) "}>} recharge_amount),'# ##0')

[Anil_Babu_Samineni]

Could be anyone of these?

=num(sum( {$<[Year of date]={$(=Max([Year of date])-1)},[Calendar date]={"<$(=Date(AddYears(Today(),-1)))"}>} recharge_amount),'# ##0')

OR

=num(sum( {$<[Year of date]={'$(=Date(Max([Year of date])-1))'},[Calendar date]={"<$(=Date(AddYears(Today(),-1)))"}>} recharge_amount),'# ##0')

[prashantsanchet]

Hope this will help:

num(Sum({<[Year of date] = {"= Max([Year of date])-1" },[Calendar date]={"<$(=Date(AddYear(Today(),-1))"} >}recharge_amount),,'# ##0')

[Colin-Albert · Accepted solution]

Prashant - To evaluate a function within a set expression you need to enclose the expressions in $(= )

so  = Max([Year of date])-1  will not work,  $(= Max([Year of date])-1 ) is correct. 

Assuming that the field [Year of date] is numeric, there is no need to enclose the set modifier value in quotes.

The error is due to the brackets not matching in the second modifier for Calendar Date

[master_student]

Thanks a lot. all of you