Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))
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)
Thanks that worked!