I've creating a report in Crystal Reports 10. I need to create a formula to exclude some line items from the report. This is what I need to do:
"Total for line items that do not have CostType_CD = 'Expense'. then a Total for line items that do have CostType_CD = 'Expense'. (I assume is one forumula)
Next formula would be:
Sum of ReserveAmount1 for all reserves where ReserveType1_CD in ('Bodily Injury', 'Expense', 'Pulmonary Disease')
Do I need to create groups?
I need very explicit instructions, I've only attended a two day Intro class on Crystal. Therefore, if any of this sounds strange, tell me so, I'm learning.
Thanks in advance