Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am getting at if statement in below code:
SalesTable:
Load , sum() as Revenue, if(
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?
Hi,
Let try this
Load
sum() as Revenue,
sum(if(
Resident Operations
Group by ;
Regards,
Sokkorn
Thanks. Works