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
Page 1 / 1
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
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.