How do I insert data from a field using 2 different date parameters

Question

Example..

I want to have for example product (Bronidox 1160) display data for 1/1/16-6/30/16 and also data for 1/1/17-6/30/17.

capture.png (5.5 kB)

Answer 1

Ian Waterman Answered Jun 16, 2017 at 08:13 AM

0

Create two formula

@Range1

If datefield >= 1/1/17-6 and datefield <= 6/30/17-6 then valuefield else 0

Repeat for other date range and place in details and suppress detail section,

Group by product and then you can then perform summaries on these two formula as required.

Ian

Share

Comment

Find Questions & Answers