Skip to main content
Question

How to highlight lines with shortages in customer order lines?

  • November 8, 2021
  • 1 reply
  • 126 views

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 2 replies

Hello, 

I would like to do something like the conditional formatting in Excel: 

If(Sales Qty - Reserved Qty - Picked Qty - Delivered Qty > Available Qty ; text in red)

 

Is it possible?

 

Thanks for your support. 

1 reply

Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1482 replies
  • November 8, 2021

The only way you can do this calculation would be to create a custom field that contains the logic to do the calculation and return a boolean answer.  Then perform the conditional formatting on that column.  You can’t do calculations or references to other columns in the context of using conditional formatting.  Additionally, conditional formatting goes away in Aurena, so anything you come up with as a business process is not likely to continue in the future.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings