Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Will you Please share the formula and what you want to achieve as I don't find any formula in excel
Yellow field has only a numeric value.
The formula in the yellow cell is : =-(1-(J12/K12))
The formula in the yellow cell is : =-(1-(J12/K12))
Hi,
I am not able to find formula column in attached excel.
Regards
Hi,
The formula in the yellow cell is : =-(1-(J12/K12))
Hi,
Use TOTAL Keyword
try like
-(1-(sum(total<dimen1,dim2> [TMT Pondéré])/sum(total<dimen1,dim2> [TMT Cible Pondéré])))
REgards
May be,
In a text box, = -(1-Sum(J)/Sum(K))