Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a numerical field (EXP_AMT) that contains positive and negative numbers.
I want to be able to script the positive numbers from that field into an (EE_Spend) field and negative into (EE_Credit) field, still retaining the original (Exp_Amt)
Please see attachment
Your assistance would be gratefully received..
yes, the attachment was confusing but thought my text explained the problem. Anyway now resolved by adding a field, saving to another QVD and reloading.then running info from Shahbaz. I just thought there was an easier way.. thanks to all for your help.