
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 24, 2024 05:07 AM
{Rate (from Contract LU)}/{Frequency (from Contract LU)}
Rate is a currency field and Frequency is a number field. Both reside in the Contract LU table.
I have been using the above simple formula in invoicing successfully for quite a while. I recently had to create a pro rated invoice for the first time, so I could not use the formula as is.
My approach at the moment is to create a checkbox field for pro rated invoices if it is pro rated. To use it I need to be able to write a formula that allows me to enter a pro rated amount if the pro rated checkbox is checked or to allow the original formula to continue if it is not checked.
First, is this the best way to do this? Second, how do I write the new beginning of the formula to allow an input.
Many thanks in advance.
Scott
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 24, 2024 05:25 AM
Hello,
You could try something like that:
Formula for field "Amount" is:
Hence if "Pro rated" is checked, field "Pro rate" is the numerator, otherwise field "rate" is the numerator.
You could also do without the check box, and have a condition on "pro rate" value being provided or not:
Regards,
Pascal
