Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyNew 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
Try =
IF([Materials Needed] - [Available Items] < 0, 0,,[Materials Needed] - [Available Items]
)
lucadelicio
Impactful Individual
Impactful IndividualTry =
IF([Materials Needed] - [Available Items] < 0, 0,
,[Materials Needed] - [Available Items]
)
)
AllanBerceshi lucadelicio thank you, work very well