Edit Value of Summary Field

[ren]

Is it possible to edit the value of a summary field type? e.g. I have a summary field type of Total Price of $4000 but due to some circumstances, I need to modify that $4000 to $3500. The ideal solution would be if I am able to leave the original total price of $4000 then copy that value to a text field type and edit the $4000 to $3500 in that new field. Currently, I cannot modify either my original total price nor my copied total price.

Any ideas/solutions will be much appreciated.

Cheers,

Ren

[Sxeptomaniac]

How about using a calculation with the GetSummary() function instead of a summary field? You would need three fields for this, your summary field, a number field for your override, and a calculation field.

You would define your calculation to be something like this:

Let ( Override = OverrideField ;

Case ( IsEmpty ( Override ) ; GetSummary ( Grand_Total ; Grand_Total ) ; Override ) )

You would then place the calculation field on the layout where your Summary field goes. You can then place the override field underneath the calculation field, and set the calculation field so it can't be entered in browse mode.

The calculation above assumes you are only using the summary as a grand total. If you need to use it as a subsummary, that would be a whole different matter, and I'm not quite sure how that would be done.