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 % w...
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])
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])
Anonymous
Thank you for your sharing
Paul