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: 
srujanaponnuru
Creator
Creator

Converting numbers to days in expression

Hi All,,

I have a requirement . i have written one expression 

sum(actuals) and the result gives me in a number. 

but i have to convert that number into days. 

if FTE i calculated as Sum({<Metric _Name = {'FTE'}>}Actuals) i need to get the result in days. 

 

REgards

srujana

Labels (1)
5 Replies
Rohan
Specialist
Specialist

Hello,

What is the data in "Actuals" field ? is it a timestamp value ?

Regards,

Rohan.

srujanaponnuru
Creator
Creator
Author

its not timestamp, in actuals we have in numbers like 0.98M

Kushal_Chawda

@srujanaponnuru  What actual number represents? Hours? Seconds? Minutes?

srujanaponnuru
Creator
Creator
Author

The actual numbers are like 1.456$, 93.40% etc

Aydenlia
Contributor
Contributor

What does your Apply to Each loop through? Or where does your data you are looping through come from?