Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i would like to create a formula for divide the total of a brand with the total of every brand.
there is a formula to solve my problem?
help me!
Marco
Hi Marco,
Use this:
Sum([YourField]) / Sum(Total [YourField])
Jordy
Climber
hi Jordy,
Thank you for your answer,
but where do i put the function 'total' with function with set analysis?
Marco
Hi Marco,
You do this in front of the set analysis:
Sum({$< Field = {1} >}[YourField]) / Sum(Total {$< Field = {1} >} [YourField])
Jordy
Climber