RANKEQ - #INVALID VALUE

Gaurav Chauhan

=RANKEQ([YTD Revenue]@row, [YTD Revenue]:[YTD Revenue], 0)

Hello,

Can you throw some light. A similar equation is working fine in one of the sheets and this one is throwing an Invalid value error.

How do I fix it.

Carson Penticuff

Are you receiving this error on all rows, or only specific ones?

Gaurav Chauhan

Thank you. I was able to resolve the same considering that the Revenue values were not formatted correctly. thank you.