I am having a data value showing -Infinity. How can i convert this to zero value?
Can you try creating a new line item with the formula: IF Payback*0 = 0 then Payback else 0. You can then update the Payback line item directly.
Thanks @ankit_cheeni - it works. Not really sure why it has that inifinity value.
Create a new line item or maybe edit the formula in the above one and use this check:
If a new line item is created then,
IF ABS(Payback) <> VALUE("Infinity") THEN Payback ELSE 0