Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FRx statement in Common Form?

Status
Not open for further replies.

Shipley

Technical User
Feb 23, 2005
8
US
Is there an easy way to accomplish this? Ideally from creating a new column format?
 
I Don't see anything, what do you want to accomplish.

can you more deatils

-b
 
I'm looking to create an income statement that has the actual financial numbers in one column, and a common form (percentage of "X") column beside it.

The basis for computing the percentage would be the financial number "A" divided by the base financial number "X"... then the next line item would show the actual financial number for "B" with the percentage of "B" divided by "X" in the next column... then on the next line, the financials for "C" in one column, and "B" divided by "X" in the next column... and so on.

Generally, the most common base ("X") is sales. So the report would show actual dollar values, and then what percent of sales that number is.
 
You can use calculated columns in your column layout. You can also change the base row (divisor) in the row format.

Format the column as a percentage.

Thanks!
Barb E.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top