AUGForums.com

An Acumatica User Group

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

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Generic I...
Formula for GI capt...
 
Notifications
Clear all

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

Questions Formula for GI caption

Acumatica Generic Inquiries & Pivot Tables
Last Post by Rick Piester 1 month ago
5 Posts
3 Users
1 Likes
2,221 Views
RSS
Ellie
Posts: 127
 Ellie
Topic starter
August 24, 2018 4:45 pm
(@ellie)
Member
Joined: 3 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.

4 Replies
Royce Lithgo
Posts: 552
 Royce Lithgo
August 27, 2018 8:32 pm
(@roycelithgo)
Member
Joined: 3 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: 3 years ago

Member
Posts: 127
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: 552
 Royce Lithgo
August 28, 2018 5:37 pm
(@roycelithgo)
Member
Joined: 3 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: 11
 Rick Piester
February 21, 2023 4:26 pm
(@rpiester)
Member
Joined: 2 months 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
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,268 Topics
  • 9,982 Posts
  • 1 Online
  • 1,834 Members
Our newest member: Derek Wong
Latest Post: Change the number of rows in the check remittance field
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.

‹›×

    ‹›×