Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i don´t what i´m doing wrong but i need to know if is possible to add if(..) when we join a table as i show below,
----
left join Load
"Month",
level,
if(("top25_cust_pay"='1'),(Sum( "Paying Customer_12")/sum(Active_Customer_Total)),0) as Top25_National_PayingCustomer
resident [LanguageList-3-9] group By "Month",level;
----
in general yes, just make sure you are using correct syntax
the load statement can be an aggregation, make sure all dimensions that arent aggregated are in the group by (including the field in the if statement)