topic Sum SET expression doesn't work. in App Development

Sum SET expression doesn't work.

materi — Fri, 16 Aug 2019 07:08:41 GMT

Hi everyone! Can anyone please tell me why the following expression doesn't work:

Sum({$<A={'x'},B={$(vMonth)}>}C) - Sum({$<A={'x'},B={$(vMonth)}>}D)

Each of the Sum({$<A={'x'},B={$(vMonth)}>}C) expressions work independently, but the minus operation doesn't do anything. What am I missing? I'm pretty sure this is the correct syntax to use for this operation, and I get no error messages. The result I get is that the last Sum expression isn't counted and it's as if only the first Sum expression exists.

Re: Sum SET expression doesn't work.

tresB — Fri, 16 Aug 2019 07:17:50 GMT

Which object are you using this expression in? Does it work in a kpi object?

Re: Sum SET expression doesn't work.

materi — Fri, 16 Aug 2019 07:36:04 GMT

Yes, but I've also tried it in a table with the same result. I also set the displaying options of the value to use 9 decimals, so I don't think the size is an issue either.

Re: Sum SET expression doesn't work.

tresB — Fri, 16 Aug 2019 07:49:14 GMT

I meant it for different granularity but size. Could you share a sample app to have a look ?

Re: Sum SET expression doesn't work.

materi — Fri, 16 Aug 2019 10:39:08 GMT

Thanks but I solved it! 🙂