record_id priority
num00001 1
num00002 1
num00003 2
num00004 2
Hi guys, new CR developer here. I have 4 records that I created a group for. Now I want to subtotal the group (i.e. there are 2 priority 1 and 2 priority 2 records). I need to have the totals on the report footer page and the crosstabs functionality does not allow the format that I want. I figured that I could draw the figure that I wanted and insert two formula fields.
count ({table_name.sum_priority_1}) = "1"
count ({table_name.sum_priority_2}) = "2"
I was then going to insert these formula fields into my homemade chart, but the formula doesn't work!!!!!!
Any suggestions? Your help would be greatly appreciated.
num00001 1
num00002 1
num00003 2
num00004 2
Hi guys, new CR developer here. I have 4 records that I created a group for. Now I want to subtotal the group (i.e. there are 2 priority 1 and 2 priority 2 records). I need to have the totals on the report footer page and the crosstabs functionality does not allow the format that I want. I figured that I could draw the figure that I wanted and insert two formula fields.
count ({table_name.sum_priority_1}) = "1"
count ({table_name.sum_priority_2}) = "2"
I was then going to insert these formula fields into my homemade chart, but the formula doesn't work!!!!!!
Any suggestions? Your help would be greatly appreciated.