Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=-(1-(sum(TMT Pondéré) / sum(TMT Cible Pondéré))
I tried but it doesn'y work. 😞
Can you share QVW??
HI,
Try like this
=-(1-(sum(TOTAL TMT Pondéré) / sum(TOTAL TMT Cible Pondéré))
Regards,
Jagan.
Hello Jagan.
It doesnt work as well.
It says expression ok but doesnt give any figure.
Thanks,
Hasvine
Hi,
Can you share your qv file? Is the fields TMT Pondéré & TMT Cible Pondéré are numeric?
Regards,
jagan.
No they are in 'hh:mm:ss' format.
I cannot share the QVW as it contain very sensitive data unfortunately. Lots of graphs. 😞
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.