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
Thanks you Mark this helps :)
@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.
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.