Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have a following problem. I'm currently using a variable and a switch panel to switch between two counts condition of ordernumbers in a barchart.
For instance the measures are like that:
if(vFormula='1',
Count({$<Packaging={1},Status={'delivered'},Delivered={1}>}Ordernumbers),
Count({$<Packaging={1},Status-={'delivered'},Delivered={0}>}Ordernumbers))
That works very well as long there is only one Date dimension listed. But if I also need to switch the dimension, because for the already delivered orders I need the actual "delivery date" when it was finished:
if(vFormula='1', DeliveryDate.autoCalendar.Date, GeneralDate.autoCalendar.Date)
Sometimes the switching works, but after two or more times it seems that he doesn't keep up the speed of switching like the measure. As if it stuck with the last dimension. Almost like a bug.
Does someone has a solution to that?
Thank you in advance.
Best.
I can't replicate the error; but I would ensure that you wrap your formula in :
$(vFormula)
and you don't need the quotes around 1, since its a numeric value.
Just ensure your button input value looks something like below:
=if($(vFormula)=1,0,1)
I can't replicate the error; but I would ensure that you wrap your formula in :
$(vFormula)
and you don't need the quotes around 1, since its a numeric value.
Just ensure your button input value looks something like below:
=if($(vFormula)=1,0,1)