Forum Discussion
Solved
Measures
Hi, I have the following 3 measures built: Sales current year to date sales last year to date sale % change year to date I added a column called "products "with the measures listed. I am ha...
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 year
So it looks like this: Sales % Chg = Divide([Sales CYTD],[Sales LYTD)-1