wrong sum

[soniasweety]

Hi All,

tresesco

felipedl‌

kaushik.solanki‌

jyothish8807‌

neelamsaroha1575‌

dx.anupam‌

balabhaskarqlik‌

simone.spanio

i am using   pivot table

Dimension :

Product

Measure: 1   :

service  :

=If(sum({<SERVICE_TYPE={'Service'}>}Amount)/1000000000 > 1,

Num(round(sum({<SERVICE_TYPE={'Service'}>}Amount)/1000000000),'$ ####B'),

If(sum({<SERVICE_TYPE={'Service'}>}Amount)/1000000>1,

Num(round(sum({<SERVICE_TYPE={'Service'}>}Amount)/1000000),'$ ####M'),

Num(round(sum({<SERVICE_TYPE={'Service'}>}Amount)/1000),'$ ####K')))

Measure2:

HW:

=If(sum({<SERVICE_TYPE={'Hardware'}>}Amount)/1000000000 > 1,

Num(round(sum({<SERVICE_TYPE={'Hardware'}>}Amount)/1000000000),'$ ####B'),

If(sum({<SERVICE_TYPE={'Hardware'}>}Amount)/1000000>1,

Num(round(sum({<SERVICE_TYPE={'Hardware'}>}Amount)/1000000),'$ ####M'),

Num(round(sum({<SERVICE_TYPE={'Hardware'}>}Amount)/1000),'$ ####K')))

Measure 3:  this is total  sum(Measure1)+sum(Measure2)      or column1 +column2

=If(sum(USD_Amount)/1000000000 > 1,

Num(round(sum(Amount)/1000000000),'$ ####B'),

If(sum(Amount)/1000000>1,

Num(round(sum(Amount)/1000000),'$ ####M'),

Num(round(sum(Amount)/1000),'$ ####K')))

My issue is   Measure3  Total  is not giving the correct result     you can refer the screen shot.   what is the issue?  can anyone help me on this?

Thanks

Sony

[qlikviewwizard]

Hi sony sing

Did you test?