G
Guest
How do I set up a report where I need to add the values from 2 fields in the
same report? Each of the two fields are calculated fields. For example:
CalculatedActual:
=Sum((IIf([Ind]="Actual-LIHTC",[1],"0"))+(IIf([Ind]="Actual-HTC",[1],"0")))
and
CalculatedOriginal:
=Sum((IIf([Ind]="Original-LIHTC",[1],"0"))+(IIf([Ind]="Original-HTC",[1],"0")))
to come up with Field called Difference which is [CalculatedActual] -
[CalculatedOriginal].
I really appreciate your help.
same report? Each of the two fields are calculated fields. For example:
CalculatedActual:
=Sum((IIf([Ind]="Actual-LIHTC",[1],"0"))+(IIf([Ind]="Actual-HTC",[1],"0")))
and
CalculatedOriginal:
=Sum((IIf([Ind]="Original-LIHTC",[1],"0"))+(IIf([Ind]="Original-HTC",[1],"0")))
to come up with Field called Difference which is [CalculatedActual] -
[CalculatedOriginal].
I really appreciate your help.