Value

HCL Domino Domino Forum
1

I am trying to get the results from the code below, I am doing this in a View both of the items have value in other columnsnow i just want to multply them together and get a new result

But I get an error saying Incorrect data type for operator or @Function: Number expected

I have both of them as a number, GrandTotal is currency and Percent is percent.

What am I doing wrong ?

This is how I have it.

GrandTotal * Percent

Thanks in advance !

2

Subject: Value

Are you sure the documents data is actually a number? Look at the document properties

For security though, try this

@if(@iserror(@tonumber(GrandTotal)) | @iserror(@tonumber(Percent));“error”;@tonumber(GrandTotal)*@tonumber(Percent))

3

Subject: RE: Value

Thank you !! the code you have has made it work

4

Subject: RE: Value

Just remember that fixes it for the view. YOu really should check to determine why a number is saved as Text. It may creep up somewhere else, again, and biut you again in Lotus Script or on your form.