how to calculate ratio

[Anonymous]

Hi everyone, hope you doing well. 

May I know how can I calculate filter based on the example below. 

I want to calculate the percentage of invoice amount that have a contract number. 

For exmaple, picture below shown that 100, 200, 300 have a contract number beside . so the ratio should be  100 + 200 + 300 = 600 divide by the total invoice amount 100 + 200 + 300 +100 = 700. 

600/700 = 85%

thank you. 

regards

[DimaMD · Accepted solution]

Hi,@Anonymous Is this your result?
  

[Anonymous]

hi @DimaMD ,

yes ! thank you so much !