data showing -infinity

Options
tompatrick.ting
tompatrick.ting
in Integrations and extensibility

Hi,

I am having a data value showing -Infinity. How can i convert this to zero value?

image.png

Thanks,

Tom

Best Answer

  • ankit_cheeni
    ankit_cheeni
    Answer ✓
    Options

    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.

Answers

  • tompatrick.ting
    tompatrick.ting
    Options

    Thanks @ankit_cheeni - it works. Not really sure why it has that inifinity value.

    Regards,

    Tom

  • HimanshuRaj
    HimanshuRaj
    Options

    Hi @tompatrick.ting

    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

    Cheers!!

Categories