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.
Could you please re-frame your requirement. I am finding it difficult to answer what you want.