GI question - trying to pull both ytd and mtd sales from ARTran. I can filter ytd in GI conditions, can I then filter the MTD on the results grid? Do you have an example of the result grind filter somewhere for this ?
Question
GI filter question
+8Hi
You can use a formula in the results grid, like this:
=Iif(year([ARTran.TranDate])=year(Today()) and month([ARTran.TranDate])=month(Today()), [ARTran.CuryTranAmt], 0)
You can also use an aggregation to sum.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Perfect - I love community --- I get faster answers here than from my company with a dozen consultants (or however many there are)
Dale Simmerly / K&R Consulting
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.