Using a Calculation field within another calculation

[darrenh]

Hi…

Your app looks and works great… i’ve come to a point whereby i need to be able to use existing mulitple calculation fields and create a total value from this. i.e.:

Subtotal 1 = 15 (where 15 is based fields number1 + number2 etc)

Subtotal 2 = 10 (where 10 is based fields number3 + number4 etc)

Subtotal 3 = 5 (where 5 is based fields number5 + number6 etc)

TOTAL = Subtotal 1 + Subtotal 2 + Subtotal 3

Someone’s probably already asked this question before in the forum, but can’t see any reference to this. I don’t want to have to duplicate the same calculations in the TOTAL field just to get this value, seems redundent…

Can this be done????

Thanks

[Brendan]

Hello Darren,

Tap Forms doesn’t allow calculation fields to use other calculation fields internally. Because it could get recursive and get into an infinite loop. E.g. Total = Subtotal 1 + Subtotal 2 + Total. Or worse, Total = Subtotal 1 + Subtotal 2 where SubTotal 2 is based on Subtotal 1 + Total. You get what I mean hopefully.

Thanks,

Brendan

[Author]

Posts