Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to sum values as below except for the numbers begins with '7'.
Cound you please help?
thank you.
Numbers | Amount |
100 | 200 |
250 | 600 |
700 | 100 |
780 | 50 |
782 | 750 |
May be like this:
Sum({<Numbers -= {'7*'}>} Amount)
Try
Sum({<Numbers -= {'7*'}>} Amount)