If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Getting error "QE-DEF-0387 Invalid format for numeric prompt"

Started by cat23, 15 Jan 2019 05:33:34 PM

Previous topic - Next topic

cat23

Hello.
I am new here. I need a help with a prompt that gives me an error when I run and leave empty field.
My filter is "[REMAINUSAGE] <  ?SEL_LEASTUSAGE?"
RemainUsage is a calculate field (Field 1 - Field 2)
When I run the report and add the value in SEL_LEASTUSAGE prompt it is running fine.but I need to have empty field or add % to retrieve all data, i have the error.

I have tried add in filter: [REMAINUSAGE] <  ?SEL_LEASTUSAGE? or ?SEL_LEASTUSAGE? IS NULL same error

I don't know where I can add the data type = numeric or change it to string
thank you

Andrei I


MFGF

Hi,

How about using a prompt macro with a default value of 0 specified, eg

[REMAINUSAGE] < #prompt('SEL_LEASTUSAGE', 'integer', '0')#

MF.
Meep!