Forum Discussion
Dax error
Hello guys,i have a problem with my Profit Column,I'm getting negative values and it's messing up my data,and here's how i calculated it; Sales Amount - Unit Cost * Quantity Sold
Please help me out
hello Diportee97
i think the formula should be reviewed.
for example:
the first line in your screenshot
Sales Amount is $2.749,17
Unit Cost is $2.037,41
Quantity Sold is 34
if the formula is "Sales Amount - (Unit Cost * Quantity Sold)", the result will be negative.
however it will be positive if the formula is "(Sales Amount - Unit Cost) * Quantity Sold"
Hope this will help.
Thank you.
1 Reply
hello Diportee97
i think the formula should be reviewed.
for example:
the first line in your screenshot
Sales Amount is $2.749,17
Unit Cost is $2.037,41
Quantity Sold is 34
if the formula is "Sales Amount - (Unit Cost * Quantity Sold)", the result will be negative.
however it will be positive if the formula is "(Sales Amount - Unit Cost) * Quantity Sold"
Hope this will help.
Thank you.