InfoPath recalculation using rules

%3CLINGO-SUB%20id%3D%22lingo-sub-490116%22%20slang%3D%22en-US%22%3EInfoPath%20recalculation%20using%20rules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490116%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20currently%20working%20on%20a%20from%20for%20a%20sharepoint%20library.%20Part%20of%20the%20form%20has%20a%20field%20that%20is%20calculated%20by%20a%20rule%3A%3C%2FP%3E%3CP%3EIF%20Field%20A%20%26gt%3B%20800%2B%20Field%202%20*100%3C%2FP%3E%3CP%3ESet%20field%203%20to%20%26gt%3B%20Condition.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20if%20the%20numbers%20change%2C%20field%203%20does%20not%20recalculate%20to%20a%20lesser%20value%2C%20only%20if%20it's%20a%20greater%20than%20value%20as%20stated%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20work%20around%3F%20I've%20tried%20using%20direct%20formulas%2C%20but%20end%20up%20with%20a%20false%20and%20true%20instead%20of%20an%20actual%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20is%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello, I am currently working on a from for a sharepoint library. Part of the form has a field that is calculated by a rule:

IF Field A > 800+ Field 2 *100

Set field 3 to > Condition.

 

My problem is if the numbers change, field 3 does not recalculate to a lesser value, only if it's a greater than value as stated above.

 

Is there a work around? I've tried using direct formulas, but end up with a false and true instead of an actual number.

 

Any assistance is appreciated.

 

Thank you!

 

0 Replies