FRx Reporting-External Worksheet?

[gkimmerpai]

I have to link an external worksheet value to a row format in Frx 6.7

I'm trying to divide the amounts on the P&L in the row format by the value in the external worksheet. It's not working at all....I've been told it can't be done but I find that hard to believe.

Got ideas?

Thanks

 

[barbola]

I would do it this way:

In the Row Format create a combined GL & Worksheet link and select the worksheet file that contains your values.

Let's assume column C has your YTD values.

To place the information contained in cell B10 of your worksheet into column C of your report, your link would be

@WKS (C=B10)

Then you can use CBR in the next row and refer to the above row. In the column layout, you would have a calculated column( maybe column D) as C/BASE.

If you would like more info please let me know, or check out the FRx help under Row Format > Linking to External Worksheets.

barb