How to make Networkdays formula display less than 0 values

Hello,

I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd Resubmitted Invoice Receipt Date]1)) - 1. I need the formula to display “0” instead of negative numbers.

Can someone assist with a formula to resolve this issues.

Find more posts tagged with

Finance

Formulas

Reports

Automations

Accepted answers

Paul Newcome

You could wrap the whole thing in another MAX function to output the MAX of that or zero.

=MAX(0, MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd Resubmitted Invoice Receipt Date]1)) - 1)

All comments

Paul Newcome

You could wrap the whole thing in another MAX function to output the MAX of that or zero.

=MAX(0, MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd Resubmitted Invoice Receipt Date]1)) - 1)

Linda Armstrong

Good morning @Paul Newcome!

I tried many formulas from the discussion topics but I just couldn't get any of them to work. Now I see I was applying it incorrectly. I was placing the 0 before the Networkdays formula (=MAX(0, NETWORKDAYS…..

Thank you so much it worked like a charm!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.