You are viewing limited content. For full access, please sign in.

Question

Question

number of days is less than zeor

Forms
Updated July 28, 2022
asked on July 28, 2022

 Doing calcualtion in my table using this:

=DAYS360(INDEX(diff.formatteddate,ROW()),INDEX(diff.Current_Date_1,ROW()))

If it's a negative number how do i get it to return a zero instead of the negative number? 

0 0

Answer

SELECTED ANSWER
replied on July 28, 2022

You could try

=IF(DAYS360(INDEX(diff.formatteddate,ROW()),INDEX(diff.Current_Date_1,ROW()))>0,DAYS360(INDEX(diff.formatteddate,ROW()),INDEX(diff.Current_Date_1,ROW())),0)

 

2 0
replied on July 28, 2022

Bless your heard Bert!!! That worked perfectly!!!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...