How to nest an expression to avoid the use of a variable?

[Anonymous]

Hi

I would like to be able to determine the most recent non blank value of a field. Currently I can do this by creating a variable eg.

vUsedC=Max({<[Used C]={*},Month>} Month) 

then using this variable in an expression

=sum({<Month={"$(vUsedC)"}>} [Used C])

Rather than create and retain many many many variables to do this in my project, I would like to combine the two expressions something like

=sum({<Month={'Max({<[Used C]={*},Month>} Month)'}>} [Used C])

Unfortunately this is not working and I have not yet determined the placement of TOTAL that might provide the solution. Once again, any assistance would be appreciated.

Thanks

Brian

[kaushiknsolanki · Accepted solution]

Try this.

sum({<Month={'$(=Max({<[Used A]={*},Month=>} Month))'}>} [Used A])

Follow same for other 2 expressions.

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

Perhaps this?

=sum({<Month={"$(=Max({<[Used C]={*},Month>} Month))"}>} [Used C])

[Anonymous]

Thank you Kaushik and Anil.