Replacing a value in a field without having to do it in the load

[#1]

I have a list box called Payment Type. The list box is using a field called PaymentType which has values Paid, Not paid and Combined. I already have the qvds built for my data but I want to change the Combine value to Total on the listbox/display without doing my load statement again or build qvd again. Any ideas?

[kaushiknsolanki]

Hi,

   You can create a calculated listbox.

   Create a new textbox and instead of selecting field select Expression (U will find it at bottom) then type below expression

   if(wildmatch(PaymentType,'Combined'),'Total',PaymentType)

Regards,

Kaushik Solanki

[#3]

How do I create a calculated list box?

[kaushiknsolanki · Accepted solution]

Just right click on sheet and say new sheet object -> list box -> now instead of selecting field select expression and type above expression

[#5]

Thanks, it is working now.

[kaushiknsolanki]

Hi,

   Will you mark this post as answered.

Regards,

Kaushik Solanki