Error in if statement in load command

[#1]

Hi

I am getting at if statement in below code:

SalesTable:
Load , sum() as Revenue, if(=12,sum(),0) as Freight
Resident Operations
Group by ;
Join(SalesTable)
Load [SO] as , sum([Sales]) as SalesValue
Resident Sales
Group by [SO];

I have declared 2 tables: Operations and Sales and now joining these two table by field .

Can someone suggest how to write if statement?

[Sokkorn · Accepted solution]

Hi,

Let try this

Load

    ,

    sum() as Revenue,

    sum(if(=12,,0)) as Freight

Resident Operations

Group by ;

Regards,

Sokkorn

[#3]

Thanks. Works