G
Guest
Hello
I have a report that has two subreports within it. Each subreport has a
separate set of figures that are totaled using the following two formulas. I
had to re-write the subreport totals so that if they were less than $100 they
defaulted to $100.
=IIf(Sum([IPROJ_PREM])<100,100,Sum([IPROJ_PREM]))
and
=IIf(Sum([GPROJ_PREM])<100,100,Sum([GPROJ_PREM]))
There is a “Savings†formula on the main report form is what is supposed to
be the difference between these two sub-totals:
=Sum([PROJECTED_SAVE])
which is actually just a field in a table from a connection through the SQL
server to another company’s database which has already deducted the total
Gproj_prem from the total Iproj_prem. The problem is that their database
doesn’t take in to account the minimum $100.
Is there a formula that I can use to just deduct the Gproj_prem from the
Iproj_prem on the main report to give the actual difference taking the $100
minimum into account? Thanks
I have a report that has two subreports within it. Each subreport has a
separate set of figures that are totaled using the following two formulas. I
had to re-write the subreport totals so that if they were less than $100 they
defaulted to $100.
=IIf(Sum([IPROJ_PREM])<100,100,Sum([IPROJ_PREM]))
and
=IIf(Sum([GPROJ_PREM])<100,100,Sum([GPROJ_PREM]))
There is a “Savings†formula on the main report form is what is supposed to
be the difference between these two sub-totals:
=Sum([PROJECTED_SAVE])
which is actually just a field in a table from a connection through the SQL
server to another company’s database which has already deducted the total
Gproj_prem from the total Iproj_prem. The problem is that their database
doesn’t take in to account the minimum $100.
Is there a formula that I can use to just deduct the Gproj_prem from the
Iproj_prem on the main report to give the actual difference taking the $100
minimum into account? Thanks