I still battling with this page. I now need to format numbers as percentage and also replacing resukting value if=0 to "dash", settings negative values in red and in parenthesis.
So far - and with help of the experts - I have these two functions which work perfectly - except on this one column where I have values to be displaey as % "Percent", Any help is appreciated.
Here are the two funtions:
if len(pData) = 0 then
NullToZero = cdbl(0)
on error resume next
pData = cdbl(pData)
if not IsNumeric(pData) then pData = 0
NullToZero = cdbl(pData)
if valNum = 0 then
elseif valNum < 0 then
And here is a typical line of code (the ones working):
<%PrintVal(FormatNumber(NullToZero(rsData_Actual.Fields.Item("A1").Value), 0)) %>