Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

Thanks for the email. I entered the following function in the calculated Col "WAP"

However, Its still calculating the quantity for "unpriced" row. Please see the example of Ideal roffing as enclosed. P

 

Excel version Pivot of the background dataWill you suggest to create a helper (dummy column) or kindly suggest if there is somthing incorrect in the manner i have entered the function. 

 

Thanks

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous - It's difficult to see what the problem is with your example. Could you supply a dataset, or image of what you're trying to accomplish, including the measure and description of what is wrong with it?

Thanks,

Nathan