This content has been marked as final. Show 2 replies
I am getting at if statement in below code:
Load [A], sum([B]) as Revenue, if([C]=12,sum([D]),0) as Freight
Group by [A];
Load [SO] as [A], sum([Sales]) as SalesValue
Group by [SO];
I have declared 2 tables: Operations and Sales and now joining these two table by field [A].
Can someone suggest how to write if statement?