conditional formatting for the number of decimals to display in a summary field

[tomp]

I use a custom function to force the number of decimals to display in a numeric field on the layout (e.g., to display '32' as '32.000' if 3 decimals are required in one instance of use of the layout or '32.00' if 2 were required in another. An application that can be run where different currencies might apply is a possible reason for the need to do this.

I can use this same function to cause a summary field to display the proper number of decimals when the summary field is used in a 'grand summary' total.

But when the function is applied to the summary field when needed in a sub-summary part on the layout, the 'grand total' is displayed, not the sub-total.

I thought maybe that I could use 'Conditional Formatting' to solve the issue. I could create the 'conditions' ok, but the format of the number displayed is not an option for the 'format'

Any way to do this?

[Lee Smith]

I'm not sure I follow this completely, but the format that is seen in Browse mode is set in Layout Mode by selecting the field, and then selecting the Format Number (either Right Button, or Main Menu >> Format >> Number)

Or, do an Advance Search for [color:blue]+decimal +places, include the pluses in search

I would also add [color:blue]comment as the member, and narrow the search down some.

HTH

Lee

Edited April 23, 2008 by Guest
OR

[tomp]

I need to be able to vary the number of decimals displayed for a given field on a layout depending on the currency used in the application. The 'fixed number of decimal digits'feature of the 'number' format forces the user to choose one for use in every instance.

To get around this, I leave the number format as 'general format' and have a custom function to format the number into the number of decimals I need and then store it into the field.

This works fine for any standard field, and for a summary field when used in the 'grand summary' for a report. However,it does not work when using the summary field in a sub-summary part of the report. The result of using the custom function on a summary field is always the 'grand summary' value and not the partial 'sub-summary'.

Hope that clarifies it a bit - and that there is some solution!

[comment]

Use the GetSummary() function to refer to sub-summary values in a calculation formula.

[tomp]

Thank you!!