Board Thread:General Discussion/@comment-25956839-20161210151312/@comment-30967537-20170415080008

Hi MIchael,

When not playing with Power Query, I had a think about this.

I think it would be better if you used a LOWER/UPPER range for the calculation to ensure the result percentage is always between 0 and 100 percent.

e.g. LOWER = 0.01, UPPER = 5.00. These could be amended as necessary.

PERCENTAGE = ( SQRT(G) - SQRT(LOWER) ) / ( SQRT(UPPER) - SQRT(LOWER) ) * 100

This gives results heavily weighted towards lower G values ...

Just a suggestion, take it orr leave it!

Nick