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
IF(SubField(grb_omschrijving,' - ',1)=8495,SUM(BUDGETBEDRAG)*-1,SUM(BUDGETBEDRAG))
Try that - probably best in the script.
Hope this helps,
You can also try like this
If(Left(grb_omschrijving, 4) = 8495, Sum(BUDGETBEDRAG) * -1, Sum(BUDGETBEDRAG))
Hope this helps you.
Retrieving data ...