Last Evaluated Price Non-inventory item Formatted Search

Hi all,

sorry if I missed different station asking the aforesaid question but I couldn't find any:

I person immoderate items which are non-inventory items and truthful person nary Last Evaluated Price. In the wide settings, we chose the Last Evaluated Price arsenic basal terms for the Gross Profit calculation.

The circumstantial items I americium talking astir are things similar Transport Insurance oregon 3rd Party Handling Fees. These are simply costs charged to the lawsuit successful precisely the magnitude we brushwood them. Hence, I'd similar the Gross Profit to beryllium precisely 0%.

Now the question: Is determination a anticipation to automatically usage the LineTotal as GrossBuyPr but lone for those circumstantial items? I tried it with a Formatted Search but it didn't work:

SELECT CASE WHEN T0.ItemCode = '#transport' THEN T0.LineTotal ELSE T0.GrossBuyPr END arsenic GrossBuyPr
FROM INV1 T0
WHERE T0.LineNum = $[INV1.LineNum] and T0.DocEntry = $[INV1.DocEntry]

Most thankful for immoderate help!