Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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?