Hi All,

I have form variable that use a LOOKUP calculation that collects all the "amount" from the list by filtering an "ID number". + I use a SUM calculation to sum them up and get the total, so far so good.

My issue is that the reviewer should be able to modify the "amount", and the form variable should re-calculate the SUM with the modified amount.

I need to prompt the user if the amount is over the "Limit" immediately so he cant save the item until the amount is decreased. That's why I cant use a workflow, but need to do this in the form.

Can somebody help how to trigger the recalculation when the amount is changed?

Thanks

what about: SUM([Lookup values]) + 0*AmountControl

however, I do not understand how AmountControl's value could be in lookup values already. if you change it on from, it's not written yet in list. so lookup can get at best the previous value. if so, then you will have to set up the formula so that it adds up value of AmountCountrol (named control) and subtract current value of list field (item property)