Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me fix this? Error in expression.
sum
(
{$
< YearNum = {'$(=Max(YearNum-1))'} >
}
Cost
)
@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
=Sum({$<YearNum = {'$(=Max(YearNum)-1)'}>} Cost)
Try this
sum({< YearNum = {"$(=Max(YearNum)-1)"}>}Cost)
@BrunPierre Not working even after adding = & taking 1 away from Max bracket as suggested.
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.
Try this
Sum(Aggr(If(YearNum = Max(YearNum)-1, Cost), YearNum))
@AlokVerma use double quotes and make sure that Field Name used in set is valid.
=Sum({$<YearNum = {"$(=Max(YearNum)-1)"}>} Cost)
@Kushal_Chawda Please see below from the expression window. I'm using desktop version 14.54.2(Feb 2022)
@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
@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]).