I would like to be able to display the calculations (or How did you come up with this number?) for my managers.

I have a solution with many calculations and I need for some of the managers to be able to see the calculations in order to verify them. I don't want to give them admin access to actually view the field info and options, just need to have a field that can be accessed with a button or script that will show the actual calculation that is used.

How can I do this?

Edited October 7, 200916 yr by Guest

Look at the Evaluate ( ) function.

You can create a text field which contains the formula you have used, if it is a relatively static thing. You can then fill in your fields with << >>.

Example:

Forumula Used: <> + <> = <>

might display:

Formula Used: 5 + 10 = 15

Alternatively, you can set a calculation field which returns the literal text of what you are using for you calculation and then display the field, but make it uneditable.

Calculation example:

"Formula Used: " & aaa::field1 & " + " & aaa::field2 & " = " & aaa::result