Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT acct, location, amt FROM Table
- =IIF(Fields!acct.Value >= 40000 and Fields!acct.Value <= 50000, SUM(Fields!amt.Value), "0.00")
- =(IIF(Fields!acct.Value >= 40000 and Fields!acct.Value <= 50000, SUM(Fields!amt.Value), "0.00"))
- - (IIF(Fields!acct.Value >= 55000 and Fields!acct.Value <= 99999, SUM(Fields!amt.Value), "0.00"))
- =SUM(IIF(Fields!acct.Value >= "40000" and Fields!acct.Value <= "50000", Fields!amt.Value, 0))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement