Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I need to create a fix value KPI, not changing when a dimension value is filtered/selected.
Here is my formula, a division of 2 parts, but not working:
Sum({1}{<CostCenter={'4500', '4510', '4520', '4530'}>} amount)
/
Sum({1}{<CostCenter={'4540'}>} amount)
Any ideas how to get this KPI fix / static?
Thanks, Tom
Should be:
Sum({1<CostCenter={'4500', '4510', '4520', '4530'}>} amount)
/
Sum({1<CostCenter={'4540'}>} amount)
Thanks
This works but it shows a wrong value instead without thie "1".
Any ideas?