How do i do this expression in the load script

[Anonymous]

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)

[swuehl]

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.

[sat_tok52]

Use if condition

[#4]

Where condition will work. You could also use "match" in use dimension to pick the field you want