SmartList Builder and creating Calculated Fields with Extender data

Just recently, I ran into a case where the partner was creating a SmartList Builder calculated field using data from the  RM Open table (RM20101) via an Left Join table operation with the Extender Window Field Numbers . In fact, this is a very typical scenario for a lot of deployments where Extender is used, especially when you cannot use the standard Extender functionality to integrate with out-of-the-box smartlists. The original SLB calculated field look something like this: Extender Calculated Field When the SLB smartlist was deployed, a number of results came back as zero for the records where there was no entry in the Extender Window Field Numbers table, even when the Sales Amount and Current Trx Amount fields had a value in the RM Open File table

Follow this link:
SmartList Builder and creating Calculated Fields with Extender data