2 Replies Latest reply on Apr 18, 2018 4:01 AM by Francesca Grisanti

    Replacing "NULL" with "-" in calculation

    Jakob Hindsholm

      I made a calculation where i need to get the value if not null otherwise i need to return "-".

      This is my code:

       

      IF
        ISNULL((SUM([Profit]) + SUM([Capital])) / SUM([Allocated Capital ]))
      THEN
        FLOAT("-")
      ELSE 
        (SUM([Profit]) + SUM([Capital])) / SUM([Allocated Capital ])
      END

       

      However this still returns "NULL" when theres no value. Please help

      ET-V2-9E