Hey All,I'm trying to get this formula to produce one of three outcomes based on a products variance % from its target FOB, but for some reason it is not producing anything. I have used this formula multiple times successfully on other tables, but fo...
I am trying to write a formula field that will summarize the responses of three separate single select fields (Prototype 1 Cost Status, Prototype 2 Cost Status, and Prototype 3 Costing Status) so my costing team can have an idea of what proportion of...
I working on a formula that will provide me with 4 different outcomes depending on a products Variance from our target cost of product/FOB. Any products that have a variance less than -5% need to output "Red -5% or More Variance", products with a var...
Not sure how this resolved the issue, but once I turned off and reset the formula formatting, it started working properly. Thank you for the help!- Erich
Hey @Mike_AutomaticN ,I appreciate the assistance. Looks like the formula is doing exactly what I need it to do. Also, great tip on inverse order. That will be very helpful for future projects. Regards,Erich
