Sum total booking cost not working

Need help
1

Hi,

I have three dropdown fields to allow users to select adult ticket numbers, child ticket numbers and infant ticket numbers. As the booking process progresses I am doing a booking summary as illustrated. However, the formula for total booking cost isn’t calculating correctly.

image
image867×526 22 KB

This is the approach I’m taking to sum booking cost

image
image1430×503 54.2 KB

But I’m not returning the expected total but it is working as expected against each ticket type individually, e.g. adult tickets, 2 selected at £25 each, total £50 but not when I’m attempting to sum the three.
image

Any help would be appreciated.

Thanks,

2

Hi, you might want to go to your app settings → Versions → Beta feature and check the expression parenthesis

image
image921×374 21.1 KB

Your error might come from an order of execution logic. Maybe you’re multiplying by 0 at some point.

3

You can also use a math plugin, or if you are looking for more advanced formulas like excel then checkout

Formula - Excel & Math Formulas

4

This topic was automatically closed after 70 days. New replies are no longer allowed.