Dear All,
Currently I have detail filtered a report based only on a field in the report OCD > 30, what I need to do now is apply some criteria to this and unsure of the formula.
Report format is as follows
Brand-------------OCD Days------------Inventory
X 35 15000
B 105 5000
I want to filter and show only based on brand and OCD Days, basically for brand X OCD days > 90 and brand B >30 OCD days. How would I go about this, I am thinking IF statements but no idea how to write it, IF brand = X and OCD days > 90, otherwise >30...........??????????????
Any help would be gratefully appreciated!
(brand=x and days>90) or (brand<>x and days>30)
So how would you construct this, in a detail filter on brand or days OCD, sorry I am new to this and just finding my feet!
Thanks for your help!