Hello,
ifelse({Shelf Price}<300,“$300 & Below”,
ifelse({Shelf Price}<=499,“$300-499”,
ifelse({Shelf Price}<=699,“$500-699”,
ifelse({Shelf Price}<=899,“$700-899”,
ifelse({Shelf Price}<=999,“$900-999”,
ifelse({Shelf Price}>999,“Above $999”,“other”))))))
I want to replicate above code snippet while using control parameters to enter values dynamically.
ifelse({Shelf Price}<${pendprice1}, toString(${pendprice1}) & " & Below",
ifelse({Shelf Price}<=${pendprice2}, toString(${pendprice1}) & “-” & toString(${pendprice2}),
ifelse({Shelf Price}<=${pendprice3}, toString(${pendprice2}) & “-” & toString(${pendprice3}),
ifelse({Shelf Price}<=${pendprice4}, toString(${pendprice3}) & “-” & toString(${pendprice4}),
ifelse({Shelf Price}<=${pendprice5}, toString(${pendprice4}) & “-” & toString(${pendprice5}),
ifelse({Shelf Price}>${pendprice5}, "Above " & toString(${pendprice5}), “other”))))))
I’m getting error while saving the below code snippet in calculated field. Can anybody solve it?
Thank you!