Firmual to show figure if in sub group

[Cpreston]

Hi

We have a report that shows total volumes of products by sales rep and the Product group.

All furlmul's are set like the below

if {vwSalesOrderRepSummary_NoFilter.ParentID} = 2000
then {vwSalesOrderRepSummary_NoFilter.TotalVolume} else 0

This works fine, however, I have been asked to also display if the figures have a sub group of a certain type, one is 2070 and the other 2037. I tried adding the code as below and calling it test and adding it into the report but it just gives me 0.00 in the results. If I make the report look at a certain order number which I know as the productgroupid, it shows the right figure. So how do I get it to show the results when it runs for all orders. Any ideas please. Thanks in advance

if {vwSalesOrderRepSummary_NoFilter.ParentID} = 2000
And {vwSalesOrderRepSummary_NoFilter.ProductGroupID} = 2070
then {vwSalesOrderRepSummary_NoFilter.TotalVolume} else 0