sum fuction

[marcomartinetti]

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

[JordyWegman]

Hi Marco,

Use this:

Sum([YourField]) / Sum(Total [YourField])

Jordy

Climber 

[marcomartinetti]

hi Jordy,

Thank you for your answer,

but where do i put the function 'total' with function with set analysis?

Marco

[JordyWegman]

Hi Marco,

You do this in front of the set analysis:

Sum({$< Field = {1} >}[YourField]) / Sum(Total {$< Field = {1} >} [YourField])

Jordy

Climber