Hi,
So I have the following example data:
ID...HOURS (decimal type)
A 2.2
A 3.75
A 3.5
I am using this calculation to sum the integer portion of each value:
{FIXED [ID] : INT(SUM([HOURS]))}
What I also want to do is sum up figures AFTER the decimal point only. So the total should be 82.
I have tried STR/SUM/MID/FIND variations but cannot get this to work.
The reason for doing this is that I have to then convert that 82 into "hours/minutes" as the hours are currently decimalised, i.e. 30 minutes = .50.
Thanks in advance.
Thank you both Joe and Jamieson for your replies and feedback.
I modified your example calculations to suit my needs:-
STR({FIXED [ID] : STR(INT(SUM([HOURS])))})+"h "+
STR(INT(({FIXED [ID] : SUM([HOURS])}-
{FIXED [ID] : INT(SUM([HOURS]))})*60))+"m"
Thank you both for pointing me in the right direction.
Best regards.
