getting Decimal value when multiply the two integers.

[Kohli]

i have two fields, When i am multiply the 2 fields output coming only decimal values. Like these

TableA:

Time(in mins),  Cost (per min mins), Total (Time*Cost)

20,                 15,                                    0.154      

15,                 20,                                     0.168

07,                 16,                                      0.0729

09,                 14,                                     0.0925

How can i solve this issue.

[tresB · Accepted solution]

It depends on how you are getting the minutes from a timestamp field. Use minute() to get the minutes value instead of any formatting function that merely give you the minute in format without changing the value at the backend.

So try like: = Minute(timestamp)*Cost