Forum Discussion
conditional divide
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 - 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.
How can I change existing WAP column to a measure column?
When I tried to create a new measure with formula : WAP1 = DIVIDE([WAP Denominator],[WAP Numerator]); it does 0 as the result.
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.