Query Display Issue

[PointsWell]

I have a query that returns a commission rate.
The commission is stored as an integer (that is to say I commission/100 is used when I calculate). I store the commission as an integer because it is too confusing for end users to enter 0.15 in the data entry field when they are entering data - they aren't mathematically minded.

The issue is I want to append a % sign on queries (I am using standard queries and don't want to use custom queries for this as it seems like excessive overhead).

I seem to remember (possibly erroneously) that in v7 I could append to the values of a field in a query, but can't figure out how to do this in v8.

Any suggestions?

[Jaymer]

I’m not sure what you mean with the reference to v7, but I would just create a commission display String field [in the BO that is maintained by a rule] that is pre-formatted to the way you want to display it in the query column.

[idpSteve]

Why not store the decimals you use, and just display them as percentages (change the display format for the attribute in the query to #%). I think that will display 0.1 as 10% in the query result.

Regards,

Steve

[PointsWell]

Why not store the decimals you use, and just display them as percentages (change the display format for the attribute in the query to #%). I think that will display 0.1 as 10% in the query result.

I store the commission as an integer because it is too confusing for end users to enter 0.15 in the data entry field when they are entering data - they aren't mathematically minded.

[idpSteve]

Try # '%' as the display format in the query and see if that works..

[BLOMASKY]

2 answers:

When you say display is it just DISPLAY or is it for editing?

Cause one way is to have a calculated attribute (STRING) that is BO.commissionAmount + '%'

Or use HTML to display the column

Bruce