Not really similar, but I had a use case to parse the current period into a format to be able to convert to a separate date format to run in a SQL query. What I did was create an xfbr business rule and call it from the SQL statement. In this particular case, the call went like:
AND a.C1EFT>= 'XFBR(MFC_FX_Date_Converter, MonthStart,TimeMe=[|!FXU_Param_FX_ML_Select_Time!|])'
You could create a rule that creates a string of you r sum statements and pulls that back into the SQL.
Hi,
I was wondering if you could kindly provide me with a more detailed or elaborate explanation of the solution you shared.
