Below is the nested formula (@AmountMo). The report design has 2 sections - current period and YTD. The user inputs the units for both sections. Thus the Mo designation.
if ({GeneralLedgerDataSet.DataSet}={?Dataset1} and {AccountType.AccountTypeCode}="S" and {AccountCategory.Rank}>3)
then 0...
Thanks for your help LB. Below is the per unit formula. Let me know if a crosstab would work.
if {?APDActMo}=0 then 0 else
Sum ({@Amount1mo}, {AccountCategory.AccountCategory})/{?APDActMo}
Hi Madawc,
Thanks for the response. As a side note, I'm using Crystal 11. I'm still a little uncertain as to the solution to my problem. The Group Header I have setup is already a Summary of detailed account-level data. I'm having more of an issue with the layout than anything. I would like...
Is it possible to have a list of Group Footers show below a list of Group Headers on the same page, but that are driven by the same Grouping-level? As I've tried to design it, each footer always appears directly after the header that it refers to. I would like to see 2 separate sections. A...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.