The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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