AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
Row Style Help
 
Notifications
Clear all

Questions Row Style Help

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 9 months ago
4 Posts
3 Users
5 Likes
818 Views
RSS
danielbyrum
Posts: 27
 danielbyrum
Topic starter
March 22, 2022 10:04 am
(@danielbyrum)
Trusted Member
Joined: 3 years ago

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!

 

image
image
Tim Rodman reacted
3 Replies
agupta
Posts: 15
 agupta
July 7, 2022 5:17 pm
(@agupta)
Eminent Member
Joined: 3 years ago

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:

image

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/

 

Reply
Jwright, danielbyrum and Royce Lithgo reacted
danielbyrum
 danielbyrum
(@danielbyrum)
Joined: 3 years ago

Trusted Member
Posts: 27
July 11, 2022 5:23 pm
Reply toaguptaagupta

@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.

Reply
agupta reacted
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 8 years ago

Famed Member
Posts: 3044
December 27, 2022 11:32 pm
Reply toaguptaagupta

@agupta That's brilliant! Thank you for sharing that post!

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,359 Topics
  • 10.3 K Posts
  • 10 Online
  • 1,979 Members
Our newest member: Penny Tingle
Latest Post: Timecard reports/queries
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×