How To Loop Throgh a value set in Fast Formula

Summary

How To Loop Throgh a value set in Fast Formula

Content

Hi Team,

we have a requirement to pull particular balance values i tried using the DBI Items but which is not giving the exact values what i am looking due to the complex logic involved, So I created a value set that returns the balance value, but there is a problem in doing the SUM within a value set.

I want to return the balance values from value set  and then loop through the values and sum them up in the fast formula, but I haven't been able to do this. I have tried to use a WHILE loop with an EXISTS Function but it wasn't working.