Skip to main content

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?

The formula would look like this


DATEADD({order date}, {dateadd (from payment method)}&'', 'day')

For some reason, it does not work correctly without &''


The formula would look like this


DATEADD({order date}, {dateadd (from payment method)}&'', 'day')

For some reason, it does not work correctly without &''



The second parameter should be a number, but you are forcing the value into a string. Is your middle field a lookup field?



The second parameter should be a number, but you are forcing the value into a string. Is your middle field a lookup field?


Yes, it is a Lookup.

If it is a Number field in a table, there is no need for an empty string.



The second parameter should be a number, but you are forcing the value into a string. Is your middle field a lookup field?


I can (and have) created a value for "Payment Clearing Time. So it is a number now. So basically I need “Created Date” + “Number of days” = “New Date”


Reply