Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Simply put I would like to set the expression below as TKGF in the script:
SUM({$ <VAL = {"SKGF","PKGF"}>}Data)
SKGF (standard KG Forecast) and PKGF (Promotional KG Forecast) are fields in the VAL dimension.
The expression above works to give me the required amount in a chart expression but QV doe not like the Syntax in the script.
Please can you explain what is needed.
Many thanks
Gareth
hi,
you cannot use set analysis - th epart of your expression found within the curly brackets - in the script.
use some text as below:
sum(if(match(VAL,'SKGF','PKGF')>0,Data) as fldSummedData
hi,
you cannot use set analysis - th epart of your expression found within the curly brackets - in the script.
use some text as below:
sum(if(match(VAL,'SKGF','PKGF')>0,Data) as fldSummedData
Thanks Pat