Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've created a straight-table and the total for 'OFF_INVOICE ' should be 12,88%
I use this expression:
Why return me wrong result in Total?
ps:In attached xls is ok,but in qlikview (printscreen) is wrong
Regards,
Andra
Try setting the total mode to sum of rows.
48% too with total mode to sum of rows
Thanks a lot anyway!
Use Expression Total, instead of Sum of rows.
Expression Total will give you correct results.
Regards
Nitin
Nitin, with Expression Total also wrong result (48%)
Thank you too
Try putting sum() around your expression:
=Sum((1-column(15)/column(13)))
Tresesco, whit sum give me "Allocated memory exceeded" . Many thanks too
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
48%
Thanks you too
Could you please post your example app with sample data?