Calculation error

[#1]

Hello All,

I have to calculate the INDICE as per the attached spreadsheet.

The formula is

=-(1-(TMT Pondéré/TMT Cible Pondéré)

However I need only the total to be calculated.

Any idea?

I tried different ways but I cannot find the solution.(even using variable)

I copied the expression i've used for all calculation in the first row.

Many Thanks,

Hasvine

[bohravanraj]

=-(1-(sum(TMT Pondéré) / sum(TMT Cible Pondéré))

[#3]

I tried but it doesn'y work. 😞

[bohravanraj]

Can you share QVW??

[jagan]

HI,

Try like this

=-(1-(sum(TOTAL TMT Pondéré) / sum(TOTAL TMT Cible Pondéré))

Regards,

Jagan.

[#6]

Hello Jagan.

It doesnt work as well.

It says expression ok but doesnt give any figure.

Thanks,

Hasvine

[jagan]

Hi,

Can you share your qv file?  Is the fields TMT Pondéré & TMT Cible Pondéré are numeric?

Regards,

jagan.

[#8]

No they are in 'hh:mm:ss' format.

I cannot share the QVW as it contain very sensitive data unfortunately. Lots of graphs. 😞

[a_mullick]

Hi,

Using an aggr() function should work for you. See the attached example - I've broken the columns down in the table just to see what is going on, but you can condense the whole thing into one expression.