Toal Amount

[mavis]

Dear All,

In a report there are 2 fields (ClaimedAmounttxt, Exposuretxt).
Formalu in the field:
ClaimedAmounttxt--> =[ClaimedAmount]/[ValuableROE]
Exposuretxt -->
=IIf([ClaimedAmounttxt]>=[CargoDeductible],[CargoDeductible],[ClaimedAmounttxt])

At the end of the report i have the total Exposure field with the below
forumla.
=Sum(IIf([ClaimedAmount]>=[CargoDeductible],[CargoDeductible],[ClaimedAmount]))

The total amount from the above forumla is wrong. can anyone advice what is
the problem with my code?

Thanks. I need this help ASAP.

 

[Steve Schapel]

Mavis

Try it like this:
=Sum(IIf([ClaimedAmount]]/[ValuableROE]>=[CargoDeductible],[CargoDeductible],[ClaimedAmount]))

If that doesn't help, please explain, with specific examples, what you mean
by "wrong".

 

[mavis]

Hi Steve,

I had removed extra "]" in the code. It code generate out an amount, but the
amount ($20430.5) is wrong.
It is not the total of the Exopsure.
The total amount should be $1604.67+$6050+$6050+$6050+$225.06+$19979.73.

Mavis

Try it like this:
=Sum(IIf([ClaimedAmount]]/[ValuableROE]>=[CargoDeductible],[CargoDeductible],[ClaimedAmount]))

If that doesn't help, please explain, with specific examples, what you mean
by "wrong".

--
Steve Schapel, Microsoft Access MVP

Dear All,

In a report there are 2 fields (ClaimedAmounttxt, Exposuretxt).
Formalu in the field:
ClaimedAmounttxt--> =[ClaimedAmount]/[ValuableROE]
Exposuretxt -->
=IIf([ClaimedAmounttxt]>=[CargoDeductible],[CargoDeductible],[ClaimedAmounttxt])

At the end of the report i have the total Exposure field with the below
forumla.
=Sum(IIf([ClaimedAmount]>=[CargoDeductible],[CargoDeductible],[ClaimedAmount]))

The total amount from the above forumla is wrong. can anyone advice what
is
the problem with my code?

Thanks. I need this help ASAP.

 

[Steve Schapel]

Mavis,

We can continue this discussiuon in the other forum where it has come up.

 

[Andrzej Sagan]

Dear All,

In a report there are 2 fields (ClaimedAmounttxt, Exposuretxt).
Formalu in the field:
ClaimedAmounttxt--> =[ClaimedAmount]/[ValuableROE]
Exposuretxt -->
=IIf([ClaimedAmounttxt]>=[CargoDeductible],[CargoDeductible],[ClaimedAmounttxt])

At the end of the report i have the total Exposure field with the below
forumla.
=Sum(IIf([ClaimedAmount]>=[CargoDeductible],[CargoDeductible],[ClaimedAmount]))

The total amount from the above forumla is wrong. can anyone advice what
is
the problem with my code?

Thanks. I need this help ASAP.