Error is Set Expression

[AlokVerma]

Can someone help me fix this? Error in expression.

sum
(
{$

< YearNum = {'$(=Max(YearNum-1))'} >

}

Cost
)

[BrunPierre]

=Sum({$<YearNum = {'$(=Max(YearNum)-1)'}>} Cost)

[Chanty4u]

Try this 

sum({< YearNum = {"$(=Max(YearNum)-1)"}>}Cost)

[AlokVerma]

@BrunPierre Not working even after adding = & taking 1 away from Max bracket as suggested.

[AlokVerma]

Still showing "Error in expression". I tired by removing the $ already. It's little weird that this simple SET EXPRESSION is throwing error and i'm having no clue of what is going wrong.

[Chanty4u]

Try this 

Sum(Aggr(If(YearNum = Max(YearNum)-1, Cost), YearNum))

[Kushal_Chawda]

@AlokVerma  use double quotes and make sure that Field Name used in set is valid.

=Sum({$<YearNum = {"$(=Max(YearNum)-1)"}>} Cost)

[AlokVerma]

@Kushal_Chawda Please see below from the expression window. I'm using desktop version 14.54.2(Feb 2022)

[Kushal_Chawda · Accepted solution]

@AlokVerma Cost field name is not available in your data model. See the colour of YearNum column . It jas to be same colour. Check the correct field name for cost

[AlokVerma]

@Kushal_Chawda Thanks ! Figured out.

I have 2 Cost measure in my data set & was referring to incorrect Cost somehow( Cost was showing light purple color when expression was throwing error). It should have been ([Patient Details.Cost]).