1 Reply Latest reply on May 31, 2016 3:00 AM by koushik.neelakantha

    Calculation for IBP Prorata

    koushik.neelakantha

      Hello All,

       

      I have a IBP Measures and No of days this month and days elapsed this month.

       

      No of days this month and days elapsed this month calculated in Database. I need to calculate Prorata for IBP in Tableau.. Data for IBP is present for Full year in Database.

       

      Present month is May. so IBP Prorata: Jan to April IBP + May IBP/No of days this month * days elapsed this month.

       

      For June it should be Jan to May IBP+ June IBP/No of days this month * days elapsed this month and so on....

       

      I need the logic to calculate IBP Prorata taking  Previous months IBP + current Month IBP/No of days this month * days elapsed this month.

       

      Regards,

      Koushik.