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!