CRV11, Access DB
I have an income statement with groups for Revenues, COS, etc. I have the account numbers summaried and the groups summaried and a grand total. I now need to divide the COS summary total by the revenue total for a percentage. I can get Revenues to work with the following formula, but the rest of the groups are seen as zero.
if {@AcctNames} = "Revenues" then Sum ({@Amount}, {@AcctNames}) else 0
How do I make this a value and not a conditional statement?
I have an income statement with groups for Revenues, COS, etc. I have the account numbers summaried and the groups summaried and a grand total. I now need to divide the COS summary total by the revenue total for a percentage. I can get Revenues to work with the following formula, but the rest of the groups are seen as zero.
if {@AcctNames} = "Revenues" then Sum ({@Amount}, {@AcctNames}) else 0
How do I make this a value and not a conditional statement?