AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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 Analytica...
Row set using colum...
 
Notifications
Clear all

Questions Row set using column set in formula

 
Acumatica Analytical Report Manager (Financial Report Writer)
Last Post by Tim Rodman 2 years ago
2 Posts
2 Users
0 Reactions
1,267 Views
RSS
Nives Angel
Posts: 5
 Nives Angel
Topic starter
January 22, 2024 1:40 pm
(@nangel)
Active Member
Joined: 2 years ago

if I have column set for current year column and last year column

I can show information from column by referencing column letter and row code

but if I have multiple columns for different outlets it is same number accross

I am trying to write formula that would say if this is column B find column c row code, if its column d find column E row code ..but it doesn't work, ... does anyone know how this can be done

Thanks


1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
May 28, 2024 10:53 pm
(@timrodman)
Famed Member
Joined: 11 years ago

You can do something like this to detect what column you're in:

image
image

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 46 Online
  • 2,422 Members
Our newest member: Sarah Vincent
Latest Post: Nested SubReport Issue
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 © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×