cancel
Showing results for 
Search instead for 
Did you mean: 

How to display Docnum as Rangestart -> RangeEnd from paramete

former_member217682
Participant
0 Kudos

How to display Docnum as

Rangestart -> RangeEnd from parameter?

View Entire Topic
abhilash_kumar
Active Contributor
0 Kudos

Hi Adrian,

Create this formula:

Minimum({?DocNum_parameter}) & " To " & Maximum({?DocNum_parameter})

Of Course, replace {?DocNum_parameter} with the name of the prompt you've created.

-Abhilash

former_member217682
Participant
0 Kudos

Hi Abhilash,

Thank you very much.

It worked!

Cheers.

former_member217682
Participant
0 Kudos

Hi Abhilash,

Now its displaying as 1,550.00 to 1,557.00

how can i make it to display 1550 to 1557?

Thanks

abhilash_kumar
Active Contributor
0 Kudos

Use:

Totext(Minimum({?DocNum_parameter}),0,"") & " To " & ToText(Maximum({?DocNum_parameter}),0,"")

-Abhilash