Divide by Zero Warning

[ankitgupta]

I am using this formula in formula tool to calculate percentage :

ToString([Value]/[Value]*100,1,0)+"%"

But I am experiencing this warning "Divide by 0 error on record #1 in field New Value". Can someone please help me to solve this.

Thanks,

Ankit

[MarqueeCrew]

ToString([Value1]/[Value2]*100,1,0)+"%"

How about:

IF [value2] = 0 THEN "0%"
ELSE
ToString([Value1]/[Value2]*100,1,0)+"%"
ENDIF

Cheers,

Mark

[ankitgupta]

Thanks you Mark this helps :) 

[kiotsuresh]

@MarqueeCrew Hi Marq,

I'm Using the below formula in the Multi row formula tool,

([Row-1:Value]) * (1+(([Row-12:Value] - [Row-13:Value]) / [Row-13:Value]))

and getting this warning, Please help me to resolve this.

[MarqueeCrew]

If your divisor is zero you can either create an error before the formula with a message tool, filter those records out and do something special with them or include an if condition to set the value to null.