Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Group by is the issue in your script, you also need to add Description in the Group by.,
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, Description ;
Regards,
Jagan.
Hi,
Is Description column exists in the Resident table, I think it is not there in your script.
Regards,
Jagan.
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];
Hi,
Group by is the issue in your script, you also need to add Description in the Group by.,
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, Description ;
Regards,
Jagan.
Wonderful thanks Jagan