nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

data showing -infinity

tompatrick.ting

Hi,

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

Thanks,

Tom

Accepted answers

ankit_cheeni

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.

All comments

ankit_cheeni

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.

tompatrick.ting

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

Regards,

Tom

HimanshuRaj

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!!

Quick Links

Can you help?

Unanswered questions

How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…