Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use an if statement with a variable in my expression and I get no results. The variable works when I use the variable on it's own but when used with the if I get no results.
I have tried:
if(OrderQtr='Apr-Jun 2018',$(vAvgOrderCost),0)
if(OrderQtr='Apr-Jun 2018',sum($(vAvgOrderCost)),0)
sum($(vAvgOrderCost)if(OrderQtr='Apr-Jun 2018',0))
Nothing seems to work. Thanks
Thanks for the explanation. The quick fix worked. I will look into using set analysis and the other suggestion later.
Thanks a lot for your patience.