Sum SET expression doesn't work.

[materi]

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.

[tresesco]

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

[materi]

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.

[tresesco]

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

[materi · Accepted solution]

Thanks but I solved it! 🙂