8 Replies Latest reply: Feb 23, 2016 3:08 AM by Vanraj Bohra

# aggr (sum)

Hello All,

I have a huge problem. In the attached excel is a table which i managed to re create in qlikview except column "temp sum".

In yellow you will find the formula.

Is there a way or a formula which I can use to calculate the same on qlikview.

Many Thanks,

Hasvine

• ###### Re: aggr (sum)

Will you Please share the formula and what you want to achieve as I don't find any formula in excel

• ###### Re: aggr (sum)

Yellow field has only a numeric value.

• ###### Re: aggr (sum)

The formula in the yellow cell is : =-(1-(J12/K12))

• ###### Re: aggr (sum)

May be,

In a text box, = -(1-Sum(J)/Sum(K))

• ###### Re: aggr (sum)

The formula in the yellow cell is : =-(1-(J12/K12))

• ###### Re: aggr (sum)

Hi,

Use TOTAL Keyword

try like

-(1-(sum(total<dimen1,dim2> [TMT Pondéré])/sum(total<dimen1,dim2> [TMT Cible Pondéré])))

REgards

• ###### Re: aggr (sum)

Hi,

I am not able to find formula column in attached excel.

Regards

• ###### Re: aggr (sum)

Hi,

The formula in the yellow cell is : =-(1-(J12/K12))