2 Replies Latest reply: May 15, 2013 10:01 PM by Naveen Ravilla RSS

    script help in Budget Report

      Hi,

      i got a budget report for forecast vs actual revenue billed by year & by month.

      In that report, when user selects a month which is less than current month, one column should show the actual revenue, otherwise forecast amount.

      And when user selects multiple months, same logic should be applied by summing up.

       

      please help me to achieve this.

      Thanks.

        • Re: script help in Budget Report
          Sushil Kumar

          you can acheive this using conditional show in expression. in your expression check the condition checkbox..

           

          there you can put condition like =if(getfieldselections(month)=vPreviousmonth,1,0)

           

           

          calculate the previous month variable...

           

           

          HTH

          Sushil

            • Re: script help in Budget Report

              Hi Sushil,

              thanks for your help.

               

              but, we got the fiscal calendar which is 1st July - 30th June.

              so, how can I calculate the previous month variable?

               

              i tried below logic, but didn't go well.

              IF(GetFieldSelections([Fiscal Month])<month(today()),[Billed Revenue],Forecast)

               

              probably , need to create Inline table to get Fiscal Month Number?