Thursday, January 8, 2009

Notes on Signed Deals Report

Signed Deals = Deals Signed by LL
Lease Term change:
Numbervar ExtYrs:= If NumericText({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs})Then ToNumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs}) * 12 Else 0;
Numbervar ExtMos := If isnull({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos}) Then 0
Else Tonumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos});

ExtYrs + ExtMos

No comments:

Post a Comment