Forum Discussion
Measures
ttaa4455 mathematic wise the result come out negative, yes :). But if you want to do something else here then you could wrap it with an if and add a different calculation to this scenario.
Somthing like:
IF( AND([SALES] >= 0 , [SALES LAST YEAR] >= 0, [STANDARD Y/Y MEASURE], [SOMETHING ELSE])
So let's say for
Product A we had the $500 in sales this year, but last year the sales was -400 (loss).
The sales percent change should be positive right? Because we got sales this year but not last year. But when I put my measure for sales % change it's negative change. Shouldn't it be positive?
I am dividing my sales this year by sales last yearSo it looks like this: Sales % Chg = Divide([Sales CYTD],[Sales LYTD)-1
ttaa4455 mathematic wise the result come out negative, yes :). But if you want to do something else here then you could wrap it with an if and add a different calculation to this scenario.
Somthing like:
IF( AND([SALES] >= 0 , [SALES LAST YEAR] >= 0, [STANDARD Y/Y MEASURE], [SOMETHING ELSE])
