Script Expression help

[#1]

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

[pat_agen · Accepted solution]

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

[#3]

Thanks Pat