Sum calculated field on a form

[MarcinM]

Hello,

I have a calculated field on a subform, which works as required:

=IIf([currency].[column](0)='EUR';[quantity]*[price1pc]*1;[quantity]*[price1pc]*[currency].[column](1))
 

In case the chosen currency name is 'EUR',exchageRate is not applied (i.e. = 1). The values taken to the calculation are drawn from a field 'currency', which is based on a query.

I have already learnt that running total on a calculated field is not possible.

QUESTION: how to sum all values from the calculated field?

[twinnyfo]

MarcinM,

AS far as I know, the only way you could do that is in your query. Calculate all the totals before they are sent to your form/report. This may take some time if you have a lot of records.

You could also just sum all the fields you are interested in first (on your form), and then calculate at the end (if that made sense).