I want to create formula to sum 5 $ fields, however only want them to be summed when they have actually been paid. To know if it's been paid we have made a Paid checkbox.
From this I was going to make a formula to do this for us, however have got stuck.
If([Payment 1 Paid]<>ture,[Payment 1 amount]
There are 5 payment amounts and 5 Payments paid fields, how can I keep building this formula to add them all up.
Ps. If there is better way to get the same result, suggestions welcomed.