How to calculate total amout of sales in a textbox ?

[marakud971]

Hi all !

I hope you are well.

I want to display the amount of my sales in a textbox object.

Please look at the picutre in attachment.

I would like  to calculate for each ID : col nb *  col €
and obtain the sum of these calculations in a textbox

Thanks !

[rubenmarin · Accepted solution]

Hi, one option is having a field in script that multiplies both fields when loading so you only need a sum of this new field.

Other option without script modification:

sum(aggr(nb_expression*€_expression), ID)