Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing a field with a function in ActiveReport

Status
Not open for further replies.

Ausburgh

Programmer
Jul 21, 2004
62
US
This is a little complicated to explain but here I go anyway:

On an ActiveReport I have to display an "*" (in FldIndicator) if field24.datavalue (a percentage itself) is greater than my GetFiscalYearPercent function (thanks again Hypetia) or "" if not.

Needless to say I can't seem to get it to work.

Note:
field24.datavalue = field21.datavalue/field20.datavalue


I tried:
------------------------
If Field24.datavalue > GetFiscalYearPercent(Date) then
FldIndicator.datavalue = "*"
Else
FldIndicator.datavalue = ""
End if
-------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top