I have a grid that has two check fields and a total (numeric) field. There is a process for the check fields, if they are check, to add either a bracket or a <> to the amount field. However, I also need the grid to show the ABS() value of the amount instead of the actual values with negatives in front. I added it to the following code below for the Dynamic InputMask - however it did not work. Would anyone know how I could make the grid reflect an ABS value for the total field with the checkbox code still working?
Thanks!
IIF(report1.credit_chk=.T., "<99999999.99>",IIF(report1.debit_chk=.T.,"[99999999999.99]","99999999.99")