
1. Re: Help with a small Field "Case" Calculation
raybaudi Aug 31, 2013 7:51 AM (in response to shae1725)Try to have each field, in their autoenter option, this calculation:
Let (L = List ( a ; b ; c ; d ) ;Case (not IsEmpty ( L ) ; Get ( ActiveFieldContents ) ;Self)) 
2. Re: Help with a small Field "Case" Calculation
shae1725 Aug 31, 2013 2:55 PM (in response to shae1725)Thanks
The calculation works well
The only problem is I need the calculation to only work if the ( a b c d) fields are empty or containing 0.
i need to be able to enter a value in any of the individual fields without affecting the rest.

3. Re: Help with a small Field "Case" Calculation
raybaudi Sep 1, 2013 12:37 AM (in response to shae1725)Try this other:
Let(L = List ( a ; b ; c ; d ) ;Case (IsEmpty ( Self ) ; Get ( ActiveFieldContents ) ;Self)) 
4. Re: Help with a small Field "Case" Calculation
shae1725 Sep 1, 2013 1:52 PM (in response to shae1725)That works well, I have another calculation to add to the same field! I didnt want to complicate the above calculation because i really needed to fully understand how you compiled it!
If field "X" = C (MW  WW / 2) to populate fields a;b
if field "X" = E (MH  WH /2) to populate c;d
if field "X" = R ( a; b; c; d; Self)
I really appreciate your help. Many Thanks