I'm working with investment data. I have a number metrics such as "Cost" that are represented as millions of dollars. Internally the numbers have enough decimal places to represent a single dollar. The QV display format is "0.0". All of the following values would be displayed as "1.1"
1.05567
1.09967
1.085567
I must retain the full values for correct aggregation.
If I display them in a listbox or multibox, using the format "0.0", I will show "1.1" three times which is not a good user experience. One solution is to use a calculated value in the multi box of:
=round(Cost, 0.1)
This provides the correct result from the user view. Select "1.1" just once and get the bunch. However...I have many fields with many values. Using round() on all the fields slows response of the multibox to an unacceptable level.
Another approach I've considered if creating a rounded copy of the field for selection. What I don't like about that is the current selection box shows the "rounded field name". I've thought about using a trick of making my rounded field just have a space at the end of the source field "[Cost ]" but that's a trick that can cause confusion in charts.
Any other ideas? Anyone tackle this issue and do something different?
I didn't get to far in the performance testing the text() idea before I ran across a deal breaker. Numeric search ">50" will not work when the field is text().
