Hello Friends, We have a problem here, where in based on the the drop-down value, the decimal places for another column needs to be altered. Column - AmountType can have Dollar Amount or Share Amount or Percentage. Based on the selection of the above column, if the dropdown value is ShareAmount, display 4 decimal places, else two decimals in the Amount column. A direct expression is obviously not possible on the format/edit masks of the column and trying via the powerscript also does not prove useful. If the format of 1 record changes, the whole series of records also change. Does anyone here have a solution to this (using PB9.0)? Any help would be greatly appreciated.
Handle this in the ItemChanged event of the DataWindow. Something like:
String ls_mask
CHOOSE CASE dwo.Name CASE 'amount_type' CHOOSE CASE Data CASE 'dollar_amount' ls_mask = '$#,##0.00' CASE 'percentage' ls_mask = '##0.0%' CASE 'share_amount' ls_mask = '#,##0.0000' END CHOOSE
