Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, Can someone please modify my script? I am trying to determine the % change between current rents (Expense) vs market rates (New SP - Rental Rates).
My formula below is reversed. It is taking current rent / market rent and subtracting 1 from the answer to get the % . Instead, I need to modify it to take market rent / current rent and subtract 1 from the answer
LET eOverMarketPct_NMonthAnn = replace('avg(
aggr(
(
sum({<LeaseTypeExpenses = {Lease}, Expense = -{VAT, Parking, "Free Rent", Other}, #PeriodCounter = {">=@(vThisPeriodNbr)<=@(=@(vThisPeriodNbr) + $1 - 1)"}>} Amount)
* (12 / $1)
/ sum({<LeaseTypePortfolio = {Lease}>} Size)
)
/
rangeSum(sum({<[Unit of Measurement] = {SQFT}>} [New SP - Rental Rates])
,sum({<[Unit of Measurement] = -{SQFT}>} [New SP - Rental Rates]) / @(vSQMtoSQFT)
)
- 1
,[Address Suite]
)
)', '@', '$');
Provide a sample data please, so when we try it in qvw, we would understand the expected result.