AnsweredAssumed Answered

How to properly sort dropdown field data that includes text and currency

Question asked by ryan.george19 on Jun 29, 2018
Latest reply on Jul 13, 2018 by CamelCase_data

(new here and couldn't find a solutions for my question, if I missed it, sorry)

 

Currently I have the following calculation creating the pictured dropdown field data, but as you can see, the sort of the data is based on text values ($1, $10, $2, 20) instead of number vales ($1, $2, $10, $20) - how do I fix this?

 

IP_Package_Name & " " &  "($" & IP_Product_Price & ")"

 

Screen Shot 2018-06-29 at 3.38.54 PM.png

 

------------

IP_Package_Name = Text

IP_Product_Price = Currency formatting

------------

 

Screen Shot 2018-06-29 at 3.35.57 PM.png

Outcomes