Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate the Sales/Target

How To Calculate the Sales/Target % column incorrect, actual % is done? Kinldy Help   Type Target Sales % Actual By manual GIRLS 4.16 1.74 40% 41.88% LADIES 81.68 63.07 74% 7...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try a measure like

divide(sum(Table[Sales]),sum(Table[Target]))

 

The data type should be decimal/numeric