I have the field a1_total.  This field may or may not have 3 cost comparisons associated to a request.  I'm trying to create a formula that will show High, Medium, Low when there are 3 costs associated to a request.  If there are only 2, then I would like it to show High and Low.  If there is only one cost associated to the request, then I would like it to say 'N/A'.  I began my formula like the following:

 

if Maximum ({@total_save}) then 'H'
else if Minimum ({@total_save}) then 'L'
else 'M'

 

I'm getting a message stating that it's expecting a boolean.  Does anyone have an example of what I'm trying to accomplish?

 

Thank you.

 

if Maximum ({cq_letter;1.a1_total(1)}) > Minimum({cq_letter;1.a1_total(1)}) then 'H'
else if Minimum ({cq_letter;1.a1_total(1)})< Maximum ({cq_letter;1.a1_total(1)}) then 'L'
else 'M'

 

Now, it's putting 'H' next to everything.  Does anyone have any other ideas that could help?

 

Thank you.