TOTAL in straight-table?

[andradinu]

Hi All,

I've created a straight-table and the total for 'OFF_INVOICE ' should be 12,88%

I use this expression:

=1-column(15)/column(13)

Why return me wrong result in Total?

ps:In attached xls is ok,but in qlikview (printscreen) is wrong

Regards,

Andra

[Gysbert_Wassenaar]

Try setting the total mode to sum of rows.

[andradinu]

48%  too with total mode to sum of rows

Thanks a lot anyway!

[Anonymous]

Use Expression Total, instead of Sum of rows.

Expression Total will give you correct results.

Regards

Nitin

[andradinu]

Nitin, with Expression Total also wrong result (48%)

Thank you too

[tresesco]

Try putting sum() around your expression:

=Sum((1-column(15)/column(13)))

[andradinu]

Tresesco, whit sum give me "Allocated memory exceeded"  . Many thanks too

[IAMDV]

Did you try the below with "Expression Total" as TOTAL Setting?

1- ([Monthly Trend] / [Trend after on invoice])

Assuming these are the correct Label Names!

Cheers,

DV

[andradinu]

48% 

Thanks you too

[tresesco]

Could you please post your example app with sample data?