Division Calculation in expression

[vikas_nandanwar]

Hi All,

I want expression to be written in Guage for calculating Profitability with given parameters -

Where

Profit is - P1,P2,P3....Pn

Value is - V1,V2,V3....Vn

Guage should calculate - Profitability -

(P1+P2+P3+....+Pn) / (V1+V2+V3+...+Vn)

div(Sum(Profit),Sum(value)) is not working in expression

Please guide

Thanks,

Vikas

[qlikview979]

as Per your expression  Guage chart is showing result

is 4 is it correct?

[vikas_nandanwar]

Data I have provided should give me 5.1 as result in guage

[qlikview979]

Hi

as per data it was showing  result is 5

[vikas_nandanwar]

yes answer is 5

[qlikview979]

is it ok

[qlikview979]

Hi please find the attached file

[vikas_nandanwar]

Ceil do not give me perfect value

I want

Profitability to be calculated as

(Sum of total profit) / (Sum of total Value)

[qlikview979]

Hi

as per data its giving the result like

4.693917269

if u want check in text object like  :-    =sum(TOTAL  Profit)/sum( TOTAL value)

[vikas_nandanwar · Accepted solution]

I got it

Sum(Profit)/Sum(Value) gave me the desired answer.

Thanks for the help.

[rubenmarin]

Hi Vikas, if your answer is solved please mark correct/helpful answers to close the thread.