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 - 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.