topic Re: Error is Set Expression in App Development

Error is Set Expression

AlokVerma — Sat, 13 May 2023 18:04:36 GMT

Can someone help me fix this? Error in expression.

sum
(
{$

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

}

Cost
)

Re: Error is Set Expression

BrunPierre — Sat, 13 May 2023 20:08:30 GMT

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

Re: Error is Set Expression

Chanty4u — Sun, 14 May 2023 05:19:57 GMT

Try this

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

Re: Error is Set Expression

AlokVerma — Mon, 15 May 2023 11:10:17 GMT

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

Re: Error is Set Expression

AlokVerma — Mon, 15 May 2023 11:11:50 GMT

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.

Re: Error is Set Expression

Chanty4u — Mon, 15 May 2023 11:26:39 GMT

Try this

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

Re: Error is Set Expression

Kushal_Chawda — Mon, 15 May 2023 15:00:11 GMT

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

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

Re: Error is Set Expression

AlokVerma — Tue, 16 May 2023 20:00:10 GMT

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

Re: Error is Set Expression

Kushal_Chawda — Tue, 16 May 2023 20:08:51 GMT

@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

Re: Error is Set Expression

AlokVerma — Tue, 16 May 2023 20:22:57 GMT

@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]).