How do I delete subtotals that are 0.
Posted by adam k on March 28, 2001 3:17 PM
I have a block of data and I subtotal by the field name and I subtotal the field amount. I want to add the logic that:
if subtotalled amount equals 0 then
delete all the records that aggregate to 0
if not then do nothing
basically if the level 2 number is 0, I want to delete all the records in level 3 view the aggregate to that number 0.
I think it pretty straight forward but I just dont know how I would go about doing this