I am creating a calculated field for my report and want to add an IF condition in my query. However, neither the SQL format nor the Oracle SQL format is working.

Where are you doing the calculated field? Is this easy-sql, in a session or in a report script? What have you tried so far. I mean in a report field I have done stuff like total.hrs=0 ? 0.0 : past.due.hrs / total.hrs * 100 not sure what you are looking for.

I tried to do that in the Purchase Order report (tdpur440101000) where I want to print a certain calculated field if the tax code is 007 and a different calculated field if it is not. I did this:
tdpur401.cvat="007" ? ext.tax1 : ext.tax2
However, it always results in false (prints tax2) even though that tax code is clearly 007 and is printed in the report as such

In 4c4 cvat is 9 characters long and right justified. You could try something like shiftl$ - but make sure cvat is only "007" and not really something else. Plus on my 4v4 I have cvat in tdpur041 not tdpur401 - but looks like you are on a different version.

I tried to do that in the Purchase Order report (tdpur440101000) where I want to print a certain calculated field if the tax code is 007 and a different calculated field if it is not. I did this:
tdpur401.cvat="007" ? ext.tax1 : ext.tax2
However, it always results in false (prints tax2) even though that tax code is clearly 007 and is printed in the report as such

Hello, try
trim$(tdpur401.cvat)="007" ? ext.tax1 : ext.tax2

And tdpur401 is the right table (purchase positions) in LN.

Regards

Thanks Bernd.

Hello, try
trim$(tdpur401.cvat)="007" ? ext.tax1 : ext.tax2

And tdpur401 is the right table (purchase positions) in LN.

Regards

This works! Thank you so much.