Report total based on result of if function
Hi - I have a report with a formula field that states
if field a = "yes" then field b,
else if field b<field c then field b
else if field c<field b then field c
Note: field b & c are basically compared to each other and I need the smallest of the 2.
The result of this formula field is then totaled (summary) for each group. I need it total for the whole report however I cannot use a Running Total on that formula field. Does anyone have any idea how I should do this?