Convers number

[#1]

Hello i want for my budget to converse only the nummer 8495 to minus (see attached file).

It's now 22.283 and i want it to become - 22.283

[Jason_Michaelides]

IF(SubField(grb_omschrijving,' - ',1)=8495,SUM(BUDGETBEDRAG)*-1,SUM(BUDGETBEDRAG))

Try that - probably best in the script.

Hope this helps,

Jason

[jagan]

Hi,

You can also try like this

If(Left(grb_omschrijving, 4) = 8495, Sum(BUDGETBEDRAG) * -1, Sum(BUDGETBEDRAG))

Hope this helps you.

Regards,

jagan.