unless you are using some other evaluation condition (usually in a RT that is under the evaluate section and the 'use a formula' option is selected and the conditions entered there) stick with the summary functions (e.g. sum, count, distinctcount, etc). These are available in the CT by inserting the field you want to summarize into the 'summarized fields' window and selecting the type of summary using the 'change summary' button.
teh summary function results are created in the first data pass, may be pushed to the server for calculating so they are more efficient and they are not as contingent on the grouping structure in the report.
RTs (or shared variable formula's) offer greater flexibility and fine tuning of when or what to evaluate on but happen in a later data pass and are very dependant on the grouping and sorting in the report.
You can create a CT and alter the grouping within it completely independent of how the dat ais grouped in the report. If you insert a RT into that CT though, the RT values are dependent on the Reprrt structure so the numbers can easily get out of whack in the CT.
Edited by DBlank - 15 Aug 2014 at 6:54am
IP Logged
