Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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)
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)