Need help with an expression to Sum the total amount for only AUD currency.
Column 1 Column 2
Amount Currency
1 Aud
2 Aud
3 USD
Total: $3 AUD
Total: $3 USD
Solved
List Sum IF Currency is AUD
+1Best answer by paulk
Have a hidden column, on that column create an expression that has an if condition
If Currency = AUD then pass the amount column, else pass 0.
Do a sum on the hidden column.
Cheers
Have a hidden column, on that column create an expression that has an if condition
If Currency = AUD then pass the amount column, else pass 0.
Do a sum on the hidden column.
Cheers
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.