How to Code Calculation

[#1]

How should i code this calculation for a reload ..

ANOBOB:

SQL SELECT

'$(vCmp)/' || BOREFK AS C_KEREFK, ANOBOB.BOYEAR AS ASW_YEAR, ANOBOB.BODAOB, ANOBOB.BODAOB

FROM

$(vDb).ANOBOB ANOBOB

WHERE

ANOBOB.BOSUTA = 'A11' AND ANOBOB.BOYEAR >= 2008;

LOAD

I Know that this could be done in the SQL, but in other more complex selects some fields are very long cases, so calculating them would crate a even more crazy sql statement.

C_KEREFK, ASW_YEAR, (BODAOB-BODAOB) AS BODOPEN RESIDENT ANOBOB;

[#2]

Sorry found the error in the code

[#3 · Accepted solution]

Had twice the same field in the select, a Ctrl-V / P that went wrong and i didn't verify the code of the select.