Guys,
First off, apologies for posting this at the end of a similar thread, my error, bit frazzled yesterday,Anyway....
using Crystal XI and I need to get a maximum out of multiple fields.
My fields are located in GH3 and I have 5 fields though it is quite probable that not all will be completed.
My fields are as follows:
{proc1} {procamt1)
{proc2} {procamt2)
{proc3} {procamt3)
{proc4} {procamt4)
{proc5} {procamt5)
What I need to show is the Maximum amount from fields {procamt1} through {procamt5} and show that amount AND the relevant {proc1} through {proc5} field. I then want to be able to work out that maximum field + 25% or 40% dependant on another formula I have in this heading.
sorry, there's a lot in there but I'm stumped as how to do this. Hoping the +25% will be easy enough but I need that maximum before I can work that out.
Cheers
Scott
First off, apologies for posting this at the end of a similar thread, my error, bit frazzled yesterday,Anyway....
using Crystal XI and I need to get a maximum out of multiple fields.
My fields are located in GH3 and I have 5 fields though it is quite probable that not all will be completed.
My fields are as follows:
{proc1} {procamt1)
{proc2} {procamt2)
{proc3} {procamt3)
{proc4} {procamt4)
{proc5} {procamt5)
What I need to show is the Maximum amount from fields {procamt1} through {procamt5} and show that amount AND the relevant {proc1} through {proc5} field. I then want to be able to work out that maximum field + 25% or 40% dependant on another formula I have in this heading.
sorry, there's a lot in there but I'm stumped as how to do this. Hoping the +25% will be easy enough but I need that maximum before I can work that out.
Cheers
Scott