cancel
Showing results for 
Search instead for 
Did you mean: 

How to round up TotalResponseTimeAverage(RESPTIME)

G_Prasad
05 Base Camper

How to round up TotalResponseTimeAverage(RESPTIME)

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.

1 ACCEPTED SOLUTION

Accepted Solutions
GeraldC1
Community Manager

Re: How to round up TotalResponseTimeAverage(RESPTIME)

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

Numeric-Field-Type-in-User-Defined-Field.png

 

View solution in original post

1 REPLY 1
GeraldC1
Community Manager

Re: How to round up TotalResponseTimeAverage(RESPTIME)

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

Numeric-Field-Type-in-User-Defined-Field.png

 

View solution in original post