Make into a Let() - function instead and it becomes easier and faster to calculate.
term = Suppliers::Payment_terms;
invoice_date = Invoice_date;
ddate = DueDate
terms > 0; invoice_date + terms;
ddate < invoice_date; invoice_date;
so for terms can I only use numbers and no combination text and numbers?
also will it then work with a negative number as pay date can be before check in date
thanks again for your help.
it looks like you have many, but not too many, scenarios you need to handle with your calculation. If it were me, I'd start writing down different scenarios with real dates (so you handle weekends). You can write the math next to the scenario and build your FM calculation from there.
1 of 1 people found this helpful
When it comes to calculations you can only do +/- on numeric values, but you can check more values if they are text in the Case function.
Hi Johan and David, you are correct that I have a couple scenarios and might have to rewrite.
Your suggestion to build it in the case and the little table is however what I am looking for, works for me thanks guys for your help