Scripting

RealEstate2018 — Sat, 16 Nov 2024 00:02:48 GMT

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

Re: Scripting

sk88024 — Tue, 15 Sep 2020 13:56:07 GMT

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

topic Re: Scripting in QlikView

Scripting

Re: Scripting