1 2 3 4 5
| IIF(TBL_FLUX_LEAS_RC.CODE_FLUX='FG_GEST',TBL_FLUX_LEAS_RC.[MT_FLUX] * val(NPM),
(((TBL_FLUX_LEAS_RC.[MT_FLUX]/ ((1+[TX_REFI_NOM]/ ([NPA]*100)))^ (iif(not [DT_FLUX_1] is null and not [DATE_MEF] is null,Jours360([DATE_MEF],[DT_FLUX_1]),0)/360*[NPA]))*(1-(((1+[TX_REFI_NOM]/
([NPA]*100)))^-iif(TBL_FLUX_LEAS_RC.CODE_FLUX='LOY_RELOC_NUM_FLUX',NZ(NB_RELC,0),iif(TBL_FLUX_LEAS_RC.CODE_FLUX like 'FG_*',val(NZ(NB_RELC,0))+val(NPM),IIF(TBL_FLUX_LEAS_RC.CODE_FLUX='LOYER',([NPM])-1,[NPM]))))))/ ([TX_REFI_NOM]/ ([NPA]*100)))*(1+ ([TX_REFI_NOM]/([NPA]*100))))
((([MT_FLUX]/ ((1+[TX_PREFI]/ ([NPA]*100)))^ (iif(not [DT_FLUX] is null and not [DATE_MEF] is null,Jours360( [DATE_MEF],[DT_FLUX]),0)/360*[NPA]))*(1-(((1+[TX_PREFI]/ ([NPA]*100)))^-1)))/ ([TX_PREFI]/ ([NPA]*100)))*(1+ ([TX_PREFI]/([NPA]*100))) |
Partager