This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to add a column in which value of the rows would depend on one of the variables . I have attached a sheet wherein I want the final result as column H. I have managed to get column G using a multi field formula but am unable to get Column H. The value of column H depend on the following :
- the reservation id is the same and total revenue of Hotel Code 'Package' >0 then it is a "Paid Package"
- the reservation id is the same and total revenue of Hotel Code 'Package' =0 then it is a "Free Package"
- There is no Hotel Code 'Package' then it is 'No Package'
I tried to use the multiplied formula with logic grouped by Reservation id, as below but it seems to change only the row+1 to Paid package, for eg. and the rows further remain with the same value.
IF [Reservation ID] = [Row-1:Reservation ID] AND [Row-1:Package Detail]="Paid Package" THEN "Paid Package" ELSE [Package Detail] ENDIF