PLZ HELP !!!!!!!!!!! Beginner's concern

M

Mita

When comparing data in a table, formula of "iif" is not working from
certain column.

Is there any limitaion, on number of formulas on formulas that can be
done

My table columns with formulas used are as below : (the maxoflist
formula is based on a module)

FDep: IIf([Deposit]>0,[Base Amt]*1.5,[Base Amt])
FECS: IIf([Paymode]="CASH/CHEQUE",[Base Amt],[base Amt]*1.5)
Fdepecs: IIf([FDep]>[Base Amt] And [FECS]>[Base Amt],[base
amt]*2,maxoflist([base amt],[fecs],[fdep]))
maxmult: maxoflist([base amt],[fdep],[fecs],[fdepecs])
fisd: IIf([profile] Like "*isd*",[maxmult]+1000,[maxmult])
fir: IIf([profile] Like "*ir*",[maxmult]+2000,[maxmult])
fisdir: maxoflist([fisd],[fir],[maxmult])
fbb: IIf([blackberry] Like "yes",[fisdir]+1000,[fisdir])

After this formula's of both iif and maxoflist are not working. Have
tried replacing the iif expression with maxoflist ..but doesnt work.
However, simple expression like > is working

fvasbb: IIf([fisdir]>[fbb],[fisdir],[fbb])
fdepo: [Deposit]*1.5
Final:maxoflist([credit limit],[fdepo],[fvasbb])
 
Top