2 Replies Latest reply on Jul 4, 2016 11:05 PM by nagendra sodum

    Hi , shifting hotel room nights from Hotel A to Hotel B , Based on % adding with Hotel B

    nagendra sodum

      Market samp.png

        Hi team,

      Please find the attached workbook , and requirement document,

      i need to find out the  shifting hotel room nights from Hotel A to Hotel B  and the % of Hotel A Room nights can be added to the  Hotel B and multiply by ABR . Here abr is Room night price.

       

      Please review the document , i need market level calculation of Excel Document Out put.

      Those calculated fields are are i have i need to use in Text format, Like Without dragging any market dimension and chain name in Rows or columns those calculated fields are Display the

      actual Excel file output. Here H     hotel B not having any room nights in that time we can't apply the Discount for that room nights and cant move the Hotel Nights from A  - B.

       

      Thanks,

      Nagendra