Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

New Visual Calculation_Replace Negative Value to 0

Hi Good day,

Can anyone help me on how can i replace the negative value to 0 in new visual calculation.

Thank you

Allan

  • lucadelicio's avatar
    lucadelicio
    2 years ago

    Try =
    IF([Materials Needed] - [Available Items] < 0, 0, 

    ,[Materials Needed] - [Available Items]
    )

2 Replies