Skip to Content
0

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

Jun 14, 2017 at 10:29 PM

23

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman 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
10 |10000 characters needed characters left characters exceeded