I have created an income statement of sorts using a cross tab. The user now wants the exact same thing but instead of a value they want each field to be the percentage of revenue. Is there a way to always get the value of a field and ignore the grouping in the Cross Tab? I am using this formula to get the Revenue value:
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cross-Tab
- Thread starter wanzek
- Start date
- Thread starter
- #2
Sorry! Somehow I submitted the post without everything and now when I try edit it doesn't work.
This is the formula I am using:
if {GLAC.udGLClassification}='Revenue' then {brvGLActtoBud.NetActivity}*-1
This works if the group row I am on in the cross tab is revenue. I need to be able to divide the directs, indirects, G&A, Other Income ect. by the revenue amount. How do I write a formula that will get me the value regardless of what the group in the cross tab is?
This is the formula I am using:
if {GLAC.udGLClassification}='Revenue' then {brvGLActtoBud.NetActivity}*-1
This works if the group row I am on in the cross tab is revenue. I need to be able to divide the directs, indirects, G&A, Other Income ect. by the revenue amount. How do I write a formula that will get me the value regardless of what the group in the cross tab is?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question