I am trying to create a custom formula field (Percent) off of another custom formula field (Number) that self references the Number field to find the highest (MAX) value and to convert the Number field/values into Percent.
Current Custom Formula Field (Percent) created:
Average_Daily_Eligible_Submissions__c / MAX(Average_Daily_Eligible_Submissions__c)
However, the results seem to indicate the formula isn't calculating as expected. The range of average daily eligible submissions (number) goes from 0 to 1. The record with average daily eligible submissions = 1 should return 100% (which is happening) but record with average daily eligible submissions = 0.7 (as an example) should return 70% as in 0.7/1 (ie. 1 being the max value). However the later returns 100% too currently.
Any idea how to fix this formula/or how to use MAX function appropriately?
THANK YOU SO MUCH!