How to Divide values in Qlikview

[#1]

Hi,

how does one divide values in Front End

e.g

Im sitting with:

VALUE 500 I need to see 50% of that Value which is 500 / 2

so i need a sample sum Script that can Occupy this.

Thanks

[alexandros17]

Are you using an expression?

If yes then Sum(Values) / 2

[#3]

Hi Saccone,

so now if the column im calculating contains Nulls and want to Add the Values on from a Different Field, how to Accomodate that?

Thanks.

[alexandros17]

It should be:

(Sum(Field1) + Sum(Field2)) / 2

[SatyaPaleti]

Hi Alessandro,

Try this

=Div(Valuee,2)

Thank you,

SatyaPaleti

[#6]

HI Guys,

this has to ignore all the Existing values only put in the new ones where we had nulls, because if i add the script to the current column it will divide existing numbers, so i don't want that

Thanks.