invalid prompt

[ky101]

Hello Everyone,

I am getting an invalid prompt definition error for the below ...


Select box
select db0.EHR

WHERE

@Prompt('Enter values for Rpt Year Month:','A','Measure Practice\RPT_YEAR_MONTH',mono,constrained)- 3


in the prompt definition I am trying to accomplish : when input prompt is selected from list of values eg : 201403 then subtract 3 months to get 201312.
and the result for EHR will be based o 201312.

Please let me know any errors in my definition.

Thanks

 

[hilfy]

You can't subtract a number from a string - the 'A' in your prompt says that this is a string value.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com