topic Re: Mutliple by 100 in QlikView

Mutliple by 100

bazzaonline — Wed, 08 Oct 2014 08:15:36 GMT

Hello All, Hopefully a simple one!

How do I multiply the result of the below formula by 100?

sum([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS)

Thanks in Advance

PrashantSangle — Wed, 08 Oct 2014 08:16:41 GMT

Hi,

(sum([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS))*100

Regards

maleksafa — Wed, 08 Oct 2014 08:17:29 GMT

( sum([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS) )* 100

or create a variable vSum = sum([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS) and another variable vSumMultiplied = $(vSum) * 100

bazzaonline — Wed, 08 Oct 2014 08:18:23 GMT

Thanks, sure I tried that but clearly not. Appreciate the help