If Empty Calculation Field???

[simoncpage]

2 cells

max / min

if only 1 of the 2 is filled in the other should be equal to that:

for example

0.25% / ___

should go to

0.25% / 0.25%

(and vice versa)

but

0.5% / 0.25%

should be able to be entered to?

How is this done???

Thanks

Simon

[Lee Smith]

Hi Simon,

I think this does what you have described.

Case( IsEmpty(Field2), Field1,

IsEmpty(Field1), Field2, Field1 / Field2

)

HTH

Lee

[simoncpage]

The problem with a calculation field is that it isn't modifiable which won't do - your thinking along the line of another field aren't you?

Simon

[Lee Smith]

You can use this calculation with script. Check out the Set Fields Script Step, and see if this is what you want.

Lee

[simoncpage]

Dont want to use scripts.

See attached.

I think this is going to be the only way round it. The problem is I want to use this for the search so it means having another layout just for search and using the calculation fields. Not really ideal I was hoping to get one that could work on the fly as user enters and using only 2 fields.

Simon

[simoncpage]

woops attachment in this post

test.zip

[-Queue-]

You can use a lookup, based on a self-relationship, that updates when one of the fields is changed. See attachment.

testv1.zip