LB,
Thanks for the accumulation formula. It's the cleanest since I had to export the results to Excel. I'd like to thank others for their contributions too.
BPUNC
I have a subreport which displays competitor names (one to many relationship with opportunity). I can display the competitors vertically easily (i.e., by design) but is there a way to display them horizontally as to not take so much room in the report?
I want to group on a "weekly" basis in a crosstab. I will have two parameters (start date of the qtr and an end date of the qtr). The word "weekly" is in quotations since sometimes the last week of the quarter will contain more than 5 business days. This is due to the fact...
I have the following:
FormulaA - numeric field
FormulaB - numeric field
I take the subtotals of FormulaA and FormulaB and divide it (i.e., A/B) to create FormulaC.
Now, I want to sort FormulaC (based on subtotals) but I can't. The "Sum of FormulaC" is not listed in the TopN/Sort...
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.