AugForums.com

An Acumatica User Group

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

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

Forums
AUG Forums
Acumatica Generic I...
Formula for GI capt...
 
Notifications
Clear all

Questions Formula for GI caption

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 2 years ago
6 Posts
4 Users
2 Reactions
3,608 Views
RSS
Ellie
Posts: 129
 Ellie
Topic starter
August 24, 2018 4:45 pm
(@ellie)
Estimable Member
Joined: 6 years ago

Hi,

Is it possible to use a formula on a GI caption in order to make the caption dynamic? 

Example: A month over month sales report for the current and last 2 months, i would like the column names to dynamically be named the actual month names and not "Current"," previous month " and "2 months ago".

Ultimately this would be on a dashboard in a column chart widget, showing top x customers with a column showing totaling each of the last 3 months.


5 Replies
Royce Lithgo
Posts: 557
 Royce Lithgo
August 27, 2018 8:32 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

Not possible - caption only supports static text. You could try suggesting it here:  https://feedback.acumatica.com/ideas


Reply
Ellie
 Ellie
(@ellie)
Joined: 6 years ago

Estimable Member
Posts: 129
August 28, 2018 5:13 pm
Reply toRoyce LithgoRoyce Lithgo

Thanks.

Suggested. Please vote if you think it is a good idea :).

https://feedback.acumatica.com/ideas/ACU-I-1667


Reply
Royce Lithgo
Posts: 557
 Royce Lithgo
August 28, 2018 5:37 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

+1 from me. I remember wanting to do that in the past and was kinda surprised that Captions were static text only.


Reply
Tim Rodman reacted
Rick Piester
Posts: 21
 Rick Piester
February 21, 2023 5:26 pm
(@rpiester)
Eminent Member
Joined: 3 years ago

Is there still no way to apply a formula to generate a caption?  I want to list monthiyear in columns but that changes depending on the time period specified or when the report was run.


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

Famed Member
Posts: 3193
October 20, 2023 8:21 pm
Reply toRick PiesterRick Piester

@rpiester You'd have to use Report Designer to generate a dynamic label.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 50 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
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 © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×