Hi

I am quite new to cr and I am struggling with a parameter field

I am using a SAP B1 query and I have created a report which I wish to add my own parameter field to a formula

The parameter I need is for an actual exchange rate and will look something like the below

if {Command.TotalFrgn} = 0 then {Command.LineTotal} else {Command.TotalFrgn} / {?My Parameter}

I have tried to set this in the selection expert and record but CR will not allow me. Is this possible in CR.

Please advise?

Thanks I didn't have the parameter set as a number which is why it was not populating. .. doh

Just on another topic I have managed to get the report run ok in CR and previewed in sap, however when SAP prompts me to add the CR parameter it will not allow me to add a decimalised number. Could that be an issue with CR.

I have added the parameter field to my report to check the format of the parameter which is decimalised but it still will not allow me?

Regards

Chris