Share
Report
80I am trying to populate 2 separate calculations on the same row in FRx (one column using CBR and another column using a calc driven from row format).
In column layout I have 6 columns (Desc, GL CUR, CALC B/Base, GL YTD, CALC D/Base, CALC D/Base (I am trying to populate a calculation in last column from a calc row)
In Row format I am using CBR of row 310 (net sales)
Row 190 (one of many revenue lines) has correct data in the first 5 columns but I am trying to populate the results of calculation in next row to appear in row 190 Column 6).
In row 191 I have a CAL of @610/@190 (this populates the correct percentage in this row in column 6, but I want this percentage to appear in Row 190 Column 6 so there are not 2 separate rows of data for the same description).
In row 192 I have tried several CAL calculations to move data from Row 191 Column 6 to Row 190 Column 6, but can't seem to find the correct calculation formula. For example, I've tried F190=F191 and I've tried F190=E191, but the data in F190 is always the same as data in E190.
In my scenario, I was hoping to move data to a specific row/column, but can't seem to figure out how to do this. Is there a way to move data from one row/column to another row/column?
Linda St. Peter
*This post is locked for comments
All responses (
Answers (
