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 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,121 Views
RSS
Nives Angel
Posts: 5
 Nives Angel
Topic starter
January 22, 2024 12: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: 3199
 Tim Rodman
Admin
May 28, 2024 9:53 pm
(@timrodman)
Famed Member
Joined: 10 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,527 Topics
  • 10.9 K Posts
  • 23 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
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

  • Andres Hernandez
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×