Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
How do i do this expression in the load script.
Thanks
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)
In which context (e.g. chart dimensions) are you using this expression?
If you want to do aggregations in the script, you'll need a GROUP BY clause and use aggregation functions on all fields not listed in that clause. You can filter records in an additional WHERE clause or use conditional functions within the aggregation functions.
Use if condition
Where condition will work. You could also use "match" in use dimension to pick the field you want