I have a checkboxgroup listing products and a total field.  Some of the items are the same price and when the data is stored in the response table, the list of product prices that have been selected is stored as a comma-delimited string in the response field. 

the options have a question portion and a value portion.  The demo page says use the format Value01_price, but when I do that the total field is populated with text (NaN).  It will only total if I use numbers only.

EG User sees:
choose product
prod1 10.00
prod2 10.00
prod 3 10.00
prod 4 10.00

Total 0

Say the user orders prod 1 and prod 4.  the results are stored in the Questionresponse table

results in a query of question, questionResponse and questionOption tables is:
question             Response      question option
choose product    10.00,10.00   product1
choose product    10.00,10.00   product2
choose product    10.00,10.00   product3
choose product    10.00,10.00   product4
Total                  20

result string is 10.00,10.00 in all cases - how can I tell which products were ordered?

cheers

Hi Rokhi,
Can you please set up a quick sample on www.betasprings.com and we can then check in and try and help you. The login is host, dnnhost.
Thanks

Yes... This option for allowing the VALUE01_10.00 and VALUE02_10.00 for sure works but will not work when it comes to actual calculations and so forth. You would need to change the client side events function call that is being used to replace the VALUE01_ and other value text within the properties before it attempts to use them in any calculation.

Thanks,

-Chad