Solved: Re: Mutliple by 100 - Qlik Community

bazzaonline · ‎2014-10-08

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 · ‎2014-10-08

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2014-10-08

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

maleksafa · ‎2014-10-08

( 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 · ‎2014-10-08

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