cancel
Showing results for 
Search instead for 
Did you mean: 

Maximum on summary fields

0 Kudos

Ia have several Summary fields in my report that I need to compare and get maximum -

I would like to do the following if possible;

maximum of these - Sum ({@JTD Cost}, {JCT_CURRENT__TRANSACTION.Job}),Sum ({@JTD Committed}, {JCT_CURRENT__TRANSACTION.Job}),Sum ({@Forecast}, {JCT_CURRENT__TRANSACTION.Job})

Accepted Solutions (1)

Accepted Solutions (1)

rakesh_m2
Contributor
0 Kudos

Hello Bill,

Calculate the summary using running totals fields instead of directly adding summary fields.  This will help you use these fields in formula fields, there by you could use the maximum function and get the required result.

Thanks,

Rakesh

Answers (0)