Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Mutliple by 100

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

1 Solution

Accepted Solutions
PrashantSangle

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

3 Replies
PrashantSangle

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
Specialist
Specialist

( 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
Creator
Creator
Author

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