Error in expression

tim_leijen — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm trying to set up an expression in a chart, to generate the budgeted Net Sales Value for a particular period (separate from the selection table)

So I've set up the expression below, but for some reason the expression doesn't work.

Sum({<GL_1={NSV}, Period ={FEB19},Dimension={BUD} >} Data)

In our script we upload the periods like this:

//Period ={'FEB19'},

// if(Period='JAN18','01-01-2018',

// if(Period='FEB18','01-02-2018',

// if(Period='MAR18','01-03-2018',

// if(Period='APR19','01-04-2018',

// if(Period='MAY19','01-05-2018',

// if(Period='JUN19','01-06-2018',

// if(Period='JUL19','01-07-2018',

// if(Period='AUG19','01-08-2018',

// if(Period='SEP19','01-09-2018',

// if(Period='OCT19','01-10-2018',

// if(Period='NOV19','01-11-2018',

// if(Period='DEC19','01-12-2018',

// if(Period='JAN19','01-01-2019',

// if(Period='FEB19','01-02-2019',

// if(Period='MAR19','01-03-2019'))

Re: Error in expression

Anonymous — Mon, 17 Sep 2018 09:52:10 GMT

in your script you Change Period to a dateformat (I suppose that FEB19 is NOT a dateformat).

In Set Analysis you use "Feb19", but Period should contain '01-02-2019'. Is this your dateformat DD-MM-YYYY?

try

Sum({<GL_1={NSV}, Period ={01-02-2019},Dimension={BUD} >} Data)

tim_leijen — Mon, 17 Sep 2018 10:51:58 GMT

Thanks that worked!