Formula with variable

analovera91 — Wed, 23 Jun 2021 12:51:38 GMT

Hello,

I´m trying to change a value in a formula by a variable, to make this flexible, but the moment I include the variable in the formula this doesn´t work anymore.

This is the initial formula I´m using:

sum({<[Daily Index]={">0 <=615"}>}Value_OK)

However, when I use a variable instead of 615 (to make it dynamic) the formula gives a wrong number:

sum({<[Daily Index]={">0 <=$(vLastUpdateDailyIndex)"}>}Value_OK)

Please note that in the variable ‘LastUpdateDailyIndex’ we are trying to dynamically calculate an index as (Month*100 + DayNumber) to calculate across different years.

Example: 15th June, Index=615 (6*100 + 15)

The variables used seem to be working fine, these are the formulas:

vLastUpdateDailyIndex = month($(vLastUpdate))*100) + Day($(vLastUpdate)

vLastUpdate = max(if(Version='Actual_2021',[Posting Date],0))

Only the formula mentioned above is not working:

sum({<[Daily Index]={">0 <=$(vLastUpdateDailyIndex)"}>}Value_OK)

Is there something wrong in the syntax?

Thanks

Re: Formula with variable

sunny_talwar — Wed, 23 Jun 2021 12:59:12 GMT

Try these

Sum({<[Daily Index] = {">0<=$(=vLastUpdateDailyIndex)"}>} Value_OK)

or this

Sum({<[Daily Index] = {">0<=$(=$(vLastUpdateDailyIndex))"}>} Value_OK)

Re: Formula with variable

analovera91 — Thu, 24 Jun 2021 08:00:15 GMT

Thanks a lot! The formula is working:

Sum({<[Daily Index] = {">0<=$(=$(vLastUpdateDailyIndex))"}>} Value_OK)

topic Re: Formula with variable in App Development

Formula with variable

Re: Formula with variable

Re: Formula with variable