1 Reply Latest reply on Dec 5, 2018 10:04 PM by Amar Wattamwar

    Parameters

    Vitor  Pratte

      I am working on a project to analyze the online sales of a hotel website.

      I am using the following calculated field:

       

      SUM(IF [Parâmetros].[Amount Type]= "1"

      AND [Billed amount] > 0 THEN([Room Nights]*[Rooms])

       

       

      ELSEIF  [Parâmetros].[Amount Type] = "2" AND [Amount Produced] <> 0 THEN([Room Nights]*[Rooms])

      END)

       

      I need to have different results in the calculation of Rooms Booking depending on the change of Billed amount and Amount Produced, since when Billed amount has values = 0 Rooms bookings do not exist.
      Thank you very much.