Original:
Lease term = if {_9_lvwLeaseSummarybyDealId_.WeaLseType}="E" then {@Term of Extension}
else {@Term Cal}
Proposed:
if {_9_lvwLeaseSummarybyDealId_.WeaLseType}="E" then
If {@Term of Extension}> 12 Then {@Term of Extension}
else {@Term Cal}
------
local numbervar Yrs := if isnull({_9_lvwLeaseSummarybyDealId_.TermYears}) then 0
else tonumber({_9_lvwLeaseSummarybyDealId_.TermYears});
local numbervar Mos := if isnull({_9_lvwLeaseSummarybyDealId_.TermMonths}) then 0
else tonumber({_9_lvwLeaseSummarybyDealId_.TermMonths});
(Yrs*12)+Mos
----
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
----
Local Numbervar ExtYrs:= If isnull({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs}) Then 0 else ToNumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs});
Local Numbervar ExtMos:= If isnull({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos}) Then 0 else Tonumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos});
(ExtYrs*12)+ExtMos
---
If ({_9_lvwLeaseSummarybyDealId_.WeaLseType}="E") Then
(If{@Term of Extension> 12}= True Then {@Term of Extension})
Else {@Term Cal};
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment