Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Forumla Help

Hello,

I have a formula similar to this;

sum(Jansales*Jantime)+sum(Febsales*Febtime)+sum(Marsales*Martime)

I need to divide the total result by 100 but can't get the expression to work.  Can you help?

Note - the time are variables.

Thanks    

1 Solution

Accepted Solutions
morgankejerhag
Partner - Creator III
Partner - Creator III

Maybe you are missing the parenthesis?

(sum(Jansales*Jantime)+sum(Febsales*Febtime)...) /100

View solution in original post

2 Replies
morgankejerhag
Partner - Creator III
Partner - Creator III

Maybe you are missing the parenthesis?

(sum(Jansales*Jantime)+sum(Febsales*Febtime)...) /100

bazzaonline
Creator
Creator
Author

Perfect,  I just couldn't get the brackets in the correct place.  Much appreciated!