How to show 0 instead of negative value in output.

[Former Member]

I am trying to calculate the # of days from start date to finished date. I did that no problem if there is value in both fields but the problem is when there is no finished date value then output is in negative (-200) instead of this value like to show in output 0.

If anyone know how please help me I really appriciate.

[former_member183777 · Accepted solution]

Create a formula:

(Finish date > 0)*(finish date - start date)

[Former Member · Accepted solution]

Thanks for your answer that work for start to finished date but i have some other to calculate. If one value is missing and output is coming in positive how can i show 0 for # of days.

thanks for help........I really appreciate if someone can help.

[Former Member · Accepted solution]

Thanks for your help but i have some positive value too which need to be( 0) because job is not finished yet means no finished date in this case what should I do. Once again thanks for your help.