Problem with sum in listBox

[#1]

Hello,

In a listBox, I want to calculate the sum of multiple entities based on the following formula:
if (X = 200 OR Y = 381, sum (if (Z = 4, amount, 0)), 0)
listBox does not work with SUM. while the same expression works well in another table in the same sheet.

[rido1421]

Hi

Can you not do your formula in the script and name it as a field?

[tresesco · Accepted solution]

You could achieve similar output with proper use of Aggr(). Try to share a sample qvw with sample data explaining expected output.

[#4]

Aggr() seems resolving the problem. your help was very helpful, thank you.