4 Replies Latest reply: Jun 10, 2014 6:38 AM by Alessandro Saccone

# Calculating column percentage with 2 identifiers

Hi everyone, I have a little issue...

I must caluclate the percentage of the column, but considering two identifiers. the formula I'm using at the moment is

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]> [QTA 1 Ordini Cliente])

where <[Descrizione Linea]> is my identifiers. I should get something like that

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]> AND <Other identifier> [QTA 1 Ordini Cliente])

i have attached two pictures to exaplain a little better what I need, so I hope I have been clear enough...

• ###### Re: Calculating column percentage with 2 identifiers

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],Other identifier> [QTA 1 Ordini Cliente])

• ###### Re: Calculating column percentage with 2 identifiers

Try

Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],[Other identifier]> [QTA 1 Ordini Cliente])

Let me know

• ###### Re: Calculating column percentage with 2 identifiers

thank you alexandros17! I was writing

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]>,<[Other identifier]> [QTA 1 Ordini Cliente])

I didn't realize both the identifiers must be within <>!

Many thanks!

• ###### Re: Calculating column percentage with 2 identifiers

Di niente Irene ... buon lavoro!