topic Re: Expression in App Development

Expression

PIAnalytical — Fri, 04 Jun 2021 14:47:32 GMT

Hello,

I have an expression that works on my KPI but does not work when I make a variable. My objective is to show the sum for the maximum date as a KPI.

=Sum({<[Month-Year]={"$(=Max([Month-Year]]))"}>}VALUE)

GaryGiles — Fri, 04 Jun 2021 17:18:16 GMT

How are you defining the variable? Can you show an example?

PIAnalytical — Fri, 04 Jun 2021 17:48:49 GMT

SET eCurrent =Sum({<Month-Year={"$(=Max(Month-Year))"}>}VALUE);

GaryGiles — Fri, 04 Jun 2021 18:13:55 GMT

I believe the $-expansion is taking place at the time you are defining the variable. Try this instead:

Let eCurrent = 'Sum({<Month-Year={"$'&'(=Max(Month-Year))"}>}VALUE)';

This way, the $-expansion will occur when you use the variable in a measure expression $(eCurrent).

PIAnalytical — Tue, 22 Jun 2021 00:37:48 GMT

No Luck. For the life of me I cannot figure out what the issue is