By using this website, you agree to our Terms of Use (click here)
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.
