conditional sum

[auralsculptor]

I am trying to create a custom function or calculation to no avail, Please help me!

a conditional sum of four fields but only if a related field has a specific value. Kind of like a sum on a found set, without the "find". I would have several of these fields for various values of the related field

The logic works like this

sum (field1; field2; field3) if (tableA::fieldX = "1")

I found a "SumConditionalFields" custom function, but could not adapt it to my needs ....

[comment]

Please do not double post.