| formula col. [message #154666] |
Tue, 10 January 2006 01:18  |
amit_garg3
Messages: 22
Registered: January 2006
Location: bangalore
|
Junior Member |
|
|
Hi
I am getting probnlem using formula column.I am calucating sum of two field using report wizard,now i want to calculate the balance to these two field.I am using formula col for that.But when i put a field in layout and set it source to formula col it always show error "field F_1 reference column F_1 below it frequency" .What to do.
Amit
|
|
|
|
|
|
| Re: formula col. [message #154871 is a reply to message #154666] |
Wed, 11 January 2006 01:44  |
amit_garg3
Messages: 22
Registered: January 2006
Location: bangalore
|
Junior Member |
|
|
Hi
I placed the field in every frame.I did not want to put it in repeating frame,as i didn't want to show the value for every field.ie repeated value.I just want to calculate the balance of the field.
Amit
|
|
|
|
| Re: formula col. [message #154888 is a reply to message #154666] |
Wed, 11 January 2006 02:58 |
irontree23
Messages: 6
Registered: January 2006
|
Junior Member |
|
|
if u are calculating balances at the report end then u must place the formula column outside the query in the data wizard else if u are calculating the balance for the group level then u must place the formula column inside the group by of the data query in data wizard.
try this
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
