Want to convert Minutes in Days in structure

[Sanjivani Wayal]

I wanted to convert 1 Hr 45 minutes to days so i followed below steps

1) i converted 1 hr 45 min in minutes by using below :-

WITH _originalestimateM = (originalestimate/60)/1000 -- it is giving me 105 which is correct

2) Now when i try to convert minutes into days which is as per formula divide by 1440 

WITH _originalestimateD = (_originalestimateM /1440)

it gives me 0 where as i wanted to decimal value which comes around 0.0729167 days

Is there a way to do it or any other way i can do it?

[Oday Rafeh · Accepted solution]

@Sanjivani Wayal 

It seems like the division is being performed as an integer division, which discards the decimal part of the result. To ensure the result is displayed as a decimal value, you can cast the numerator or the denominator to a floating-point number (float) or a decimal number.

Updated formula:

WITH _originalestimateM = (originalestimate/60)/1000
WITH _originalestimateD = (CAST(_originalestimateM AS float) / 1440)

Regards 

Oday

[Sanjivani Wayal]

WITH _originalestimateD = (CAST(_originalestimateM AS float)/1440) :

is giving me error of Invalid Expression in cloud JIRA

[Oday Rafeh]

Jira Cloud Might not support the CAST function, we can try the 'ROUND' function instead

WITH _originalestimateD = ROUND(_originalestimateM / 1440.0, 7)

[Sanjivani Wayal]

Above still gives me 0

[Oday Rafeh]

Okay, You can try to calculate the decimal value directly within the same expression:

WITH _originalestimateD = ((originalestimate / 60.0) / 1000) / 1440

[Sanjivani Wayal]

Hey it worked i used Markdown format Thank you so much for help :)

[Oday Rafeh]

Nice to hear that, 

Have a nice day