4 Replies Latest reply: May 18, 2014 10:52 PM by Bella Mae RSS

    Invalid expression question

    Bella Mae

      Hi all

       

      I am getting an invalid expression error when I reload the table below, it does however reload fine without the line highlighted in yellow.  I can't see any glaringly obvious reason for it so any guidance would be greatly appreciated. 

       

      Invalid expression

      CurrentRR:

      LOAD PML_CODE,

                  Description as [Next RR Description],

                  min([Days to expiry]) as [Days to Next expiry],

                  date(num(ReloadTime())+min([Days to expiry])) as Next_Review_Date,

                  num(ReloadTime())+min([Days to expiry]) as %Next_Review_DateDateKey

              

      Resident LeaseRentReviews

      Group by PML_CODE

        • Re: Invalid expression question
          jagan mohan rao appala

          Hi,

           

          Is Description column exists in the Resident table, I think it is not there in your script.

           

          Regards,

          Jagan.

            • Re: Invalid expression question
              Bella Mae

              Yes it exists in the resident table

               

              LOAD PML_CODE,
                  
              PMRV_DESC as [Review Description],
                  
              PMRV_EXPIRY as [Review Date],
                  
              date(PMRV_EXPIRY) as Review_Date,
                   num(PMRV_EXPIRY) as %Review_DateDateKey,
                   PMRV_FCRENT as [Rent from prior review],
                  
              PMRV_MRENT as [Current Market Rent],
                  
              PMRV_RACHET as [Fixed Ratchet Rent],
                  
              FV_AAMOUNT as [Calculated by script Annual Percentage],
                  
              FV_MRIRENT as [Calculated Market Rent Index Rent],
                  
              PerAnnumBasis as [Per Annum Basis],
                  
              PMRV_AMOUNT as [Fixed Amount],
                  
              PMRV_APERC as [Annual Percentage],

                   PMRV_ARENT as [Actual Rent],
                  
              PMRV_CPI as [CPI Percentage],
                  
              PMRV_FORECAST as [Forecasted Rent],
                  
              PMRV_FPERC as [Fixed Percentage],
                  
              PMRV_MRI as [MRI Percentage],
                  
              PMRV_NOTES as [Review Notes],
                  
              PMRV_THOLD as [Turnover Threshold],
                  
              PMRV_TPERC as [Turnover Percentage],
                  
              PMRV_TRENT as [Turnover Base Rent],
                  
              PMRV_TURNAMOUNT as [Estimated Turnover Amount],
                  
              PMRV_TURNRENT as [Turnover Rent],
                  
              FixedPercentageFigure as [Fixed Percentage Figure],
                  
              MarketIndex as [Market Index Percentage],
                  
              MarketIndex2 as [Market Index Percentage 2nd Option],
                  
              MOD_DATE as [Modified Date],
                  
              PMRVT_ANLP as [Annual Percentage1],
                  
              PMRVT_ANLP2 as [Annual Percentage 2nd Option],
                  
              PMRVT_CM as [Current Market],
                  
              PMRVT_CM2 as [Current Market 2nd Option],
                  
              PMRVT_CPI as [CPI Percentage1],
                  
              PMRVT_CPI2 as [CPI Percenatge 2nd Option],
                  
              PMRVT_DESC as Description,
                  
              PMRVT_FIXA as [Fixed Amount1],
                  
              PMRVT_FIXA2 as [Fixed Amount 2nd Option],
                  
              PMRVT_FIXP as [Fixed Percentage1],
                  
              PMRVT_FIXP2 as [Fixed Amount 2nd Option1],
                  
              PMRVT_TURNP as [Turnover Amount],
                  
              PMRVT_TURNP2 as [Turnover Amount 2nd Option],
                  
              Description as Status,
                  
              if (Description='Available', (num(PMRV_EXPIRY)-num(ReloadTime())),Null()) as [Days to expiry]