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.
Can you not do your formula in the script and name it as a field?
You could achieve similar output with proper use of Aggr(). Try to share a sample qvw with sample data explaining expected output.
Aggr() seems resolving the problem. your help was very helpful, thank you.
Retrieving data ...