i'm working on creating an aging inventory report for items with a receipt date greater than 30 days.
I've started with this if statement,
sum (if(Today()-Receipt Date>30, Inventory))
However my challenge presents itself in the receipt date because an item has several receipt dates(in and outbound). I need the first date for which there was an order. i can get that seperately by using this set analysis.
min({$<Order-={0}>} date(Receipt Date))
Is there anyway to combine the if statement and set analysis? Or should i go a different route?
