This topic is locked
[SOLVED]

 List Page Calculate Column

1/12/2011 5:44:57 PM
ASPRunnerPro General questions
author

I want to create a calculated column that displays on the list page. I placed it in a custom view of an empty field on the list page.

if (rs("RTMinCount")) = 0 then

strValue = rs("RTMinCount")

elseif rs("RTMinCount") > 0 then

strValue = Cint(rs("RTMinCount"))/sum(Cint(data("RTMinCount")))

end if


I can get it to diplay each component, but not calculate. I get a "Type mismatch: 'sum' " error.
Anyone? Please and thank you!

Sergey Kornilov admin 1/14/2011

Is that a ASPRunnerPro or ASPRunner.NET question?

4414 1/18/2011

Sorry, its ASPRunnerPro 6.3. >

Is that a ASPRunnerPro or ASPRunner.NET question?

Sergey Kornilov admin 1/19/2011

There is no such thing as Sum function in ASP - that's why it breaks.
Probably you need to explain what you trying to sum there and we'll suggest a workaround.

4414 1/20/2011

Was just testing you? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=55893&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' /> I figured it out and posted the answer on my other thread. Thanks!



There is no such thing as Sum function in ASP - that's why it breaks.
Probably you need to explain what you trying to sum there and we'll suggest a workaround.