Convert WEBI Variable to SQL

[former_member194139]

I've requirement to convert the webi report to SQL query. This Webi report has below variable. How do I convert this to SQL statement. I can add this in my SQL SELECT clause.

Please help me

AMT

=sum([V_Ending_Balance]Foreach([Fin_Identifier)*If (ISNULL([V_Finding_Ask_Percent);100;[V_Finding_Ask_Pct]) Foreach([Fin_Identifier)/100)

V_Ending_Balance

=SUM([Acounting_SBLG_BLNCE_AMT]) where ([Acounting_Sys_Cmp_Typ]="UPB")

V_Finding_Ask_Percent

=[V_Finding_Ask_Percent] This is Detail object associated object Fin_Identifier

[former_member636715]

Im no expert, so maybe my version is different... but I dont have FOREACH as a function?