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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

How to simple multiply column values with 365

Its very simple task but i didn't get the correct answer 

i have field of  one_day_earning and i want to multiply that column with 365 to get Earning 

i.e 

11* 365 = 4015

but i get 4117 

 

Labels (1)
3 Replies
Kushal_Chawda
MVP
MVP

@mahnoor1279  what expression you are using?

mahnoor1279
Contributor III
Contributor III
Author

sum([ONE_DAY_EARNING]) *365

 

 is this okay?

Kushal_Chawda
MVP
MVP

@mahnoor1279  looks like your earnings column has decimal values. try to floor the values like below

floor(sum([ONE_DAY_EARNING])) *365