Generic Inquiry - Format result column with two decimal places as number

Question

In a generic inquiry, if I have a calculation field such as an aggregate SUM field is there a method to make the output column show as a number with 2 decimal places if no field in the GI schema matches that format?

For example, if I have a field SUM {TABLE} [TABLE.FIELD]/60, the resulting field only shows an integer value of say 40 instead of 40.50.

Answer 1

You can control the formatting of the column by setting the "Schema Field" column of the generic inquiry "Results Grid" tab to any field in the table which matches the type and output format you're looking for.

In your case, you could use EPTimeCard.TimeSpentCalc, but this one assumes that you're passing a total of minutes, so division by 60 you're doing would need to be removed and system would format just like it does on screen in HH:MM format

Answer 2

This worked for me: [TimeEntry.TimeSpent]/60.00

That produces 2.50 where as the following produces 2: [TimeEntry.TimeSpent]/60