Scripting

[RealEstate2018]

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]
)
)', '@', '$');

[sk88024]

Provide a sample data please, so when we try it in qvw, we would understand the expected result.