Working with portals and Sum() functions...help pls

[tightmf]

Hi,

I'm new to this and I need to have a (calculation?) field which sums a portal on the layout. The trick is: the Sum field needs to evaluate on record creation without evaluating deletion of portal rows. Basically, it should only reflect increases and not decreases (all entries will be positive values). I've looked at auto-entry and lookup approaches but can't seem to make them work.

Thanks

Mike

[Anuviel]

You could make an invisible field that would lookup the value of the field that you need to sum and your calculation would sum the lookup fields instead of the real field. The drawback is that if you changed the data in the real field it would not reflect in your sum field, even if you typed 33 instead of 32 and hit enter then corrected it, it would not reflect it.

There are much better ways to do what you want then this and this way probably is very bad but I'm new here and this is how I learn things, sorry.

[Genx]

This is probably more of a structural issue. See if this file helps you out.

falseDelete.zip