Forum Discussion

Giada_Togliatti's avatar
Giada_Togliatti
Post Patron
6 years ago
Solved

change infinity value

Hi,

how can I change the default value of infinity in a division with 0 with an empty space?

Thank you

Giada

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Giada_Togliatti  - Using DIVIDE automatically returns a blank when dividing by 0, is that what you are asking for?

     

    Measure = DIVIDE(100,0) returns blank

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Giada_Togliatti  - Using DIVIDE automatically returns a blank when dividing by 0, is that what you are asking for?

     

    Measure = DIVIDE(100,0) returns blank
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Good morning, I am trying to make a comparison of sales of premises of two periods 2021 vs 2022, when I make the percentage variation formula, I have as a result infinite since one of the premises had no sale in 2021 and in 2022 it has $ 50 K