Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
This works in a table, but do you know why it doesn't work in a KPI or Text measure?
Sum({1<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ)
/
Sum (total{1<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ)
-
Sum({1<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ)
/
Sum(total{1<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ)
Doesn't work because you always get 0?
maybe because
- total disregards the dimensions
- {1} disregards the selections
Hi Lak,
Is it possible to attach a sample qvf?
Ok, let me mock something up
I'm working on the server how do i save a file and get it to you
Sangram
I can load up pictures of the expressions for you.
Regards
Anyone? this expression is bugging me now
may be this?
(Sum({<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ)
/
Sum (total{<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ))
-
(Sum({<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ)
/
Sum(total{<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ))
Nope
But thanks
Hi Lak,
In a Table, when you use the expression its grouped by the dimension values you used, but where as when you use the same expression its will return zero because its divided by the same number itself. Ex: 10/10 = 0. Though you do not use total explicitly for the numerator its considered as total as there is no dimension.
I would suggest you to analyse this by splitting the numerator and denominator into two different KPI's or text objects and see what the results are.