I’m trying to forecast revenue for my company. I have a table, and basically what I want it to do is tell me:
If Order Date Created is “X”, and payment method is “Y”, add “Z days” to Order Date and output new date.
Can’t quite figure it out. For example, if they paid with a credit card, I know their payment will settle today. But if they paid by check, I can forecast the revenue out 2 weeks or so.
Anyone know how to do this?