continue on thread767-909827 1

[stillsteam]

Hello

I need som more help on my formula. It works great if I only use multiple discrete values BUT the users also want to be able to use Range parameters.So I need help creating a formula with Discrete and Range parameter box checked and also of course Multiple Values.

This is the formula I have for multiple discrete values:
local numbervar i;
local stringvar s;
for i:=1 to ubound({?Vilka varugrupper}) do
s:=s & {?Vilka varugrupper} & chr(13);
s;

Any help would be great

/Jonas
ps.CR8.5 and SQL

 

[lbass]

Try:

numbervar counter;
numbervar i := ubound({?parm});
stringvar result;

for counter := 1 to i do (
result := result + if minimum({?parm}[counter]) =
maximum({?parm}[counter]) then
minimum({?parm}[counter]) + chr(13) else
minimum({?parm}[counter]) + " to "+
maximum({?parm}[counter]) + chr(13));
result;

-LB

 

[stillsteam]

Worked like charm!

Thank you!
Jonas