Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 16, 2017 at 08:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded