Forum Discussion
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 having an issue where if the sales last year to date is negative and the sales current year to date is positive,
the sales % change measure is returning a negative number. That is inaccurate as we had more sales this year than last year. How can I fix that?
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])
4 Replies
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
