Downloaded ALV in excel format has different subtotals value

Hi all,

I have an ALV in which I resort to use a subroutine to calculate a subtotal value because the standard way adding up all the values doesn't fit my requirements.

The ALV grid shows the correct value but when it's exported in any format the subtotal is wrong. It seems as if my subroutine is not executed when downloading.

Any ideas why it's working like that.

Regards,