Hi,

I have created a form to collect three numbers (income1, income2 and income3) and frequency for each income (weekly as 52 - annual equivalent, fortnightly 26, month 12 and annual 1)

all are of type number in the database,

I want to show the total in a repeatedgroup as: income1*frequency1 + income2*frequency2 + income3*frequency3

I tried to do the formula apparently the calculations is not correct, I am thinking of storing the data as calculated so that the sum comes as the annual, however, I still need to be able to change the total if a dropdown menu was selected to show weekly other than annual.

I thought of using states and updating states but that comes with challenges (I haven’t tried it),

I thought of storing the total (which ultimately is what I want to show, however that is not a good design and has its own issues.

I know that parenthesis are not supported in calculations, any ideas?

Sam