Forum Discussion

Giada_Togliatti's avatar
Giada_Togliatti
Icon for Post Patron rankPost 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
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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