Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Sum if multiple criteria met
Hi
I am getting stuck with a few formulas in a saved search.
I am trying to sum all of the leave accrued entries (leave hours records) if they fall between two date fields.
Date field number 1 is 'last anniversary date'
This field is not stored anywhere.
Instead, it is calculated from date field number 2 called 'next anniversary date'. This is stored on the employee's record.
i.e. Date field number 1 ('last anniversary date') is = ADD_MONTHS({next_anniversary_date},-12)
What I am trying to calculate is the sum of 'leave hours' if they fall between last anniversary date
Tagged:
0