Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks but I solved it! 🙂
Which object are you using this expression in? Does it work in a kpi object?
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.
I meant it for different granularity but size. Could you share a sample app to have a look ?
Thanks but I solved it! 🙂