How to calculate weighted averages excluding zeros?

[pam1990]

I have a measure with =(Sum(OCC*CURR_BOOK_VALUE)/Sum(CURR_BOOK_VALUE))/100 to calculate the weighted average, but I do not want to include OCC values of zero in the weighting. How do I accomplish that?

[Digvijay_Singh · Accepted solution]

May be try this - 

(Sum({<OCC-={0}>}OCC*CURR_BOOK_VALUE)/Sum({<OCC-={0}>}CURR_BOOK_VALUE))/100

Pl share some sample data to try different options in case the above doesn't work

Thanks,

[pam1990]

That worked. Thank You!