FRX Question 2

[kkrebs]

I have a question and I hope someone can help me. On page 1 of a report I have a row labeled Benefits Allocation and it is a calculation (15%) of Labor (which is the line above it) so the line reads CAL @640 * .15 It comes out correct on page one where I have the figure subtracted from the Cost of Sales.

I also have this Benefits row on page 2 but I want it to show up as a negative amount. You know is () and I can't figure out how to accomplish this. I have tried to even mark column E with a C but it doesn't work. What am I doing wrong?

Any help would be greatly appreciated. Thank you in advance.

 

[barbola]

You can change your calculation formula to be column specific.
Instead of using @640*.15 use D=D640*.15,E=(-E640*.15).




Thanks!
Barb E.

 

[kkrebs]

I don't really understand. Both of the figures are listed in the same column but different rows on the same report. So I can't see how I would put in your formula.

 

[klewis10367]

You need to do your calcs in the Row Format, not the COlumn if you want them in the same column. For the Benefits allocation Row, under fmt code, select calc and use this formula=@"row#"*.15(Where D is the column you want your data and row# is the row number of the Benefits Allocation. Then for the Benefits row do the same thing but multiply the calc by -1. D=@"row#"*.15.

 

[barbola]

If the figures on page 2 are further down in the row format, just do another CAL row with the formula as -@640 x .15 or do a CAL and refer to the row with the other calculation -@641.









Thanks!
Barb E.

 

[kkrebs]

Thank you everyone for your help. I knew that if I asked a question, someone in here would give me the valuable answer.

Kim