Forum Discussion
conditional divide
Hi all, I need to calculate WAP by divding Sales by quantity only for columns which has been categorized as priced. The quantity under unpriced should not be added. In the WAP column below I hav...
Anonymous - It looks like you're creating WAP as a Calculated Column. It needs to be a Measure. Also, Numerator and Denominator need to be Measures.
Anonymous - Need to see the definition and results of the WAP Numerator and WAP Denominator also.
please see enclosed:
the result
The definition used :
for denominator
Anonymous - I was really baffled, but then saw the DIVIDE - Numerator needs to be first:
DIVIDE([WAP Numerator], [WAP Denominator])
Hi Nathan,
Thanks a lot for the help. It totally works now.
Thanks again.