By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
I am trying to highlight rows of a custom GI based on the comparison of values in two different 'cells'. The values are populated based on date parameters at the SOLine level. Basically the GI shows usage for stock items over the last few weeks. I would like to highlight one color when 'Last 7 Days' is greater than 'Last Week' and a different color when less than. The GI is just the SOLine DAC. I am using the date parameters at the top to bound the data for the given time period. There might be a different/better way to accomplish what I am after, so I am open to suggestions. Thanks!
You can use a formula with nested if statements in the row styles entry box. Also, to simplify, you re-use the formulas in the results table for the row style logic - run your GI and then look at the most recent trace. Each of your active result formulas will have a label that looks something like:
Once you find the correct formula labels, you can use these labels in the row styles. I learned about it from this blog post, it was very helpful: https://www.acumatica.com/blog/how-to-use-acumatica-generic-inquiry-row-styles-with-aggregated-values/
@agupta, this worked great! Thanks for sharing. It did take me a few minutes to find the formulas. I ended up deactivating all but one, and running the trace for each formula.
Online Members
