The issue I am having is I have a formula field that calculates a value based on the sum fields in a group. I am trying to get the report to sort based on this formula field (without any success). I have tried everything that I can think of to try and sort based on this field can any one please help me. Below is the forumla that I used for my calculation.
IF Sum ({viewAssy.hrsworked}, {viewassy.lineNumber}) = 0 Then 0
ELSE (Sum ({viewAssy.earnedHrs}, {viewassy.lineNumber})/Sum ({viewAssy.hrsWorked}, {viewassy.lineNumber}))*100
IP Logged