Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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,
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,
That worked. Thank You!