Expression Totals On Row

[khaycock]

Hey,

Is it possible to have the highlighted expressions amount positioned underneath the amount, so where it says total now?

I'm not sure if it is something you can actually do on QlikView?

I think it would look better than having the extra columns.

Thanks!

[vinieme12 · Accepted solution]

See attached

example:

=if(RowNo()=0,

num([Over pack per drop >5]*0.53,'£ ##,###')

,num([Over pack per drop >5]))

[khaycock]

Didnt work, the amount is still coming up as £

[#4]

Go for custom format cell option to color it

[vinieme12]

Which one?? Have you checked the app , you need to set formatting to expression default for all expressions ? Please  change the num formatting in each expression as you want it to be

[khaycock]

Ah sorry didn't see you had attached the file with it! Thanks thats amazing

[khaycock]

Is there anyway I can add a total column to sum up just the costs on the right?