[Solved] How to calculate with a calculated field?

[lachass]

Hello,

I'm trying to make an invoice for a camping with the Report builder. I have calculated two subtotals by accumulation in the report (one for the total amount and one for the TVA).
But now I need to multiply these subtotals with the number of nights people stayed (nombre de nuits).
And when people have already paid an advance that needs to be subtracted to get the real amount that people need to pay in the end.
How can I do those two things?

I have attached the database 'lachass' for anyone to check it out. The labels are in French.

[chrisb]

Hello lachass,

your aim I believe is :- (total+TVA 10%)*number of days-advance.

this is very easy to achieve when using report builder.

using your data your formula is:-

Code: Select all

([Accumulationsubtotaal TVA (10%)Report]+[AccumulationsubtotaalReport])*[aantal nachten]-[aanbetaling]

1. copy the formula.
2. drag out a text box in your footer.
3. if necessary hit (F4) to view the properties.
4. select 'General' tab then hit formatting & format to 2 decimal places.
5. select 'Data' tab.
6. 'Data Field Type' = 'Field or Formula'
7. 'Data field'= paste your formula here & hit enter.
8. execute report.

[lachass]

Hello Chrisb,

Thank you very much. It worked like a charm.
I didn't need the formula as you wrote, but the setup was clear so I could adapt it to my needs.

Cheers,
Lachass