How to separate + and - numbers from a numeric field?

[Anonymous]

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..

[Anonymous]

‌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.