How to round up TotalResponseTimeAverage(RESPTIME)

[G_Prasad]

Hi,

I have 1 display which shows TotalResponseTimeSecondsAverage(RESPTIME) in x.xxxxxx format for eg.(1.367513).

Now I want it to show in decimal format and not in float. If it is 1.367513 then it should show 1 or if it is not possible in decimal  then atleast can we truncate float value . Meaning, if it is 1.367513 then it would be 1.3 .

Same concern is applicable to fields which shows value in percentage. Now approve/decline percent fields shows data in xx.xx% format, can we round up it in 2 decimal?

For eg. If approval percent (APRV%) is 88.79% then it should show 89. Either roundUp/truncate functionality should work for these fields.

I tried using userDefineFields with Truncate/Round functionality but it is restricting me by showing following message "Expression was evaluated into a type that mismatches the user-defined field type".

kindly advise.

[GeraldC1 · Accepted solution]

You're on the right track. 

Note for everyones' reference:

Calculated fields: https://help.prognosis.com/prognosis/116/calculated-fields-13601374.html

Functions that can be used in calculated fields: https://help.prognosis.com/prognosis/116/function-button-calculated-fields-13601385.html#FunctionBut...

Just make sure that the type is changed to Numeric. Here's a screen image showing this setting.

HTH