Forum Discussion
Solved
MY GP % return wrong value
Hi All
I have a expression :-
SALES GP % = DIVIDE((SALES_T[SALES_T] - SALES_T[COST_]),SALES_T[SALES_T])
it return wrong value .
I manage to get the COST and SALES amount right . But GP % wrong. Forumla s correct.
My PBI file :-
Hope some one can advise me where go wrong ?
Paul
Hi admin11 ,
You are doing SALES_T GP % as a calculated column, hence it is proving the wrong value.
Create it as measure with the same formula and it will show you the correct result.
SALES_T GP % = DIVIDE((SALES_T[SALES_T] - SALES_T[COST_T]),SALES_T[SALES_T])
4 Replies
Hi admin11 ,
You are doing SALES_T GP % as a calculated column, hence it is proving the wrong value.
Create it as measure with the same formula and it will show you the correct result.
SALES_T GP % = DIVIDE((SALES_T[SALES_T] - SALES_T[COST_T]),SALES_T[SALES_T])
