Nan and Infinity In Divide function

Hi Anonymous 

You are getting NAN and Infinity because you are dividing 0 by 0 and 747 by blank ( where blanks it considers as zero)..

You will have to change your formula.

or you can try creating 2 quick measures. 

- 1st measure for subtraction SUM and Gross Revenue

- 2nd to divide the above measure with Gross Revenue.

Add in table to get somehting like this.

Let me know if this helps . 

Thanks,

Tejaswi