Forum Discussion
Dax error
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.
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.