Totaling issues

[QlikSenseUser2]

I'm having an issue with this. I'm trying to get the MPG for both units, but it only shows the first unit's gallons for the total.

=Sum(LOADED_MILES+DEADHEAD_MILES+TOLL_MILES)/If(Sum(TRACTOR_GALLONS)>0,Sum(TRACTOR_GALLONS),Sum([T.Fuel Gallons]))

[chrismarlow]

Hi,

Have you tried changing the Totals function to Sum or your expression?

Cheers,

Chris.

[QlikSenseUser2]

Yes and changing the Totals function to Sum works for the table the only issue is I can't do that for the gauge 

[chrismarlow · Accepted solution]

Hi,

I think you will need to wrap an AGGR round it, so something like;

Sum(Aggr(your expression, [Unit Num]))

Cheers,

Chris.

[QlikSenseUser2]

Thanks!!! That worked.