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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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

@mahnoor1279  what expression you are using?

mahnoor1279
Contributor III
Contributor III
Author

sum([ONE_DAY_EARNING]) *365

 

 is this okay?

Kushal_Chawda

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

floor(sum([ONE_DAY_EARNING])) *365