invalid numeric value (Error: WIS 10705)

building reports webintelligence
1

Hi,

I have created a report based Beach universe having the prompt on ‘Revenue’ object.

I am trying to open this report from another report using Opendocument function.The syntax reads as:

http://xxxxx:8080/OpenDocument/opendoc/openDocument.jsp?sDocName=RepLinkMeasuretst&sType=wid&sRefresh=Y&iDocid=32468&sWindow=New&lsSEnterRevenue=([Revenue])

The Effective syntax reads in the formula bar as:

="<a href=“http://xxxxx:8080/OpenDocument/opendoc/openDocument.jsp?sDocName=RepLinkMeasuretst&sType=wid&sRefresh=Y&iDocid=32468&sWindow=New&lsSEnterRevenue=”+URLEncode(""+[Revenue])+"" title="" target="_blank" nav=“web”>"+[Revenue]+""

When I click on a value (220,700) in the parent report. The value is passed as a text ‘220,700’ to the numeric Revenue prompt and getting an error that the Prompts was entered with invalid numeric value (Error: WIS 10705).

Looks like the numbers are considered in text format. Can any one suggest on the below on how to pass the value in numeric format.

I am working on this in WebI XI3.1

Thanks,
Prithvi.

prithvi (BOB member since 2005-09-08)

2

Hi :slight_smile:

I hope the revenue is number data type, but not sure why it is showing error
“invalid numeric value”, you can modify the code to pass the value as number like,

lsSEnterRevenue=tonumber([Revenue])

Cheers!

Prashu :india: (BOB member since 2005-08-17)

3

Hey Prashu,

Thanks for your response.I have used the FormatNumber function to get it correct, as ToNumber is throwing calculation error.

Thanks,
Pirthvi.

prithvi (BOB member since 2005-09-08)

4

Hi, I have met the same problem.
Can you tell me your way in solving this problem in details ?
like how to use formatNumber this function ?

chinarose2009 :cn: (BOB member since 2009-07-08)

5

I had the same problem. If you have a text and you need to do the following to make it work :

formatNumber([Revenue];“0”) this should get rid of your invalid numeric value ( WIS 10705 error)

mankato (BOB member since 2010-04-21)

6

You need to know the datatype (actual datatype, not just the type of data it stores) to know which function to use.

FormatNumber is used when your object is already a number and you just want to change the display of it.

ToNumber is used when your object is a character field and you want to convert it to a number.

They can be used in conjunction with each other to reformat a character string (perhaps to add commas).

digpen :us: (BOB member since 2002-08-15)