Hello,
I am working with a report that needs to be able to dynamically pull costs by Award by G/L under LIN codes not equal to 31672L000 (award number + L000). When I enter the formula filter criteria as "Global Dimension 3 Code", <>31672L000 I receive the results I was expecting. However, when I try to have this filter drive off of another cell (as necessary when changing the award number) I do not return the desired results. How do I syntax the <> part of the filter?
"<>C135&""L000"
"<>C135&"L000""
Another way maybe??
Thanks!
Tom
Date
Votes
1 comment
-
Jet Reports Historic Posts If you put ="<>C135" in A2, you can use the formula =A2&"L000" in B2 and refer to B2 in your Jet formula.
Or put A2&"L000" directly into your Jet formula.
HTH
rmw
Please sign in to leave a comment.