Description |
If more than one numeric fields follow sequently in a table, with FSUM you can get the sum of it.
Examples:
[STRUCTURE]
...
field_20=exchange_01:NUMBER,8,2
field_21=exchange_02:NUMBER,8,2
field_22=exchange_03:NUMBER,8,2
field_23=exchange_04:NUMBER,8,2
field_24=exchange_05:NUMBER,8,2
field_25=exchange_06:NUMBER,8,2
field_26=exchange_07:NUMBER,8,2
field_27=exchange_08:NUMBER,8,2
field_28=exchange_09:NUMBER,8,2
field_29=exchange_10:NUMBER,8,2
field_30=exchange_11:NUMBER,8,2
field_31=exchange_12:NUMBER,8,2
...
FSUM(DB,'exchange_01',month(today)) returns in May exchange_01+exchange_02+exchange_03+exchange_04+exchange_05
|