Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

We have a client that has cancelled a large number of orders (multiple items we manufacture). I'm building a report with three fields: standard cost, average cost, & last cost.

I'm struggling to find a way to identify the largest value of the three fields and have it inline (in the details section) with the other data. This will allow me to identify the max cost for each component in each assembly.

I'm pretty sure the maximum() function won't work for a group of fields. I haven't found anything helpful to address this situation while searching this or other forums. The searches usually turned up how to find a max value in a single field or to place the value in a group footer. Neither of those options work.

Any help is appreciated!

share|improve this question
    
Should this question be asked on Stack overflow? –  B-Rell Jul 31 '13 at 22:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.