topic Re: Variable with the { included in App Development

Variable with the { included

Evan0211 — Thu, 07 Oct 2021 17:00:29 GMT

I have a variable like this:

{<[Total Value]={">1000000"}>}

I am then taking that variable and using it to calculate a KPI like this:

=Count({<[Category]={'Auto'}> * $($(vFilter))}[SA Title])

The KPI should count all of the Auto columns with a total cost over 1000000.

When I get the expression back, it comes in like this:

=Count({<[Category]=['Auto']> * {<[Total Value]={">1000000"}>}}[Title])

The {...} around the <[Total Value] section is throwing errors. I have the {} in there because this also filters a table and that works correctly. Is there a way to remove the {} from the variable when I do the count for the KPI?

Re: Variable with the { included

stevejoyce — Thu, 07 Oct 2021 17:37:10 GMT

$(=textbetween('$(vFilter)','{', '}',1))

=Count({<[Category]={'Auto'}> * $(=textbetween('$(vFilter)','{', '}',1)) }[SA Title])

Re: Variable with the { included

Evan0211 — Thu, 07 Oct 2021 17:55:39 GMT

Unfortunately, that expresses to:

=Count({<[Category]=['Auto']> * - }[Title])

and says there is an error in the expression: '}' expected

Re: Variable with the { included

stevejoyce — Thu, 07 Oct 2021 18:01:32 GMT

You're right, that will not get after first }. try this instead:

$(=right(left('$(vFilter)', len('$(vFilter)') - 1), len('$(vFilter)') - 2))

=Count({<[Category]={'Auto'}> * $(=right(left('$(vFilter)', len('$(vFilter)') - 1), len('$(vFilter)') - 2)) }[SA Title])

Re: Variable with the { included

Evan0211 — Thu, 07 Oct 2021 18:18:45 GMT

That did the trick thank you so much!

Re: Variable with the { included

stevejoyce — Thu, 07 Oct 2021 18:25:46 GMT

Great. please mark correct solution so thread can be closed.

Re: Variable with the { included

Digvijay_Singh — Thu, 07 Oct 2021 18:27:18 GMT

May be this works as well, not sure -

=Count({<[Category]={'Auto'}> * $(=replace('$(vFilter)','{<','<'))[SA Title])