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
-------------------------
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
-------------------------