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


    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])



      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.