Hello all,
I have a report with different Qtys based on different dates and need help displaying together. I’m using and and ors in the one query to generate different qtys for two different date ranges then have split them out with an if statement variable.
I have the live qty showing correctly and I only want to show lines with a live qty present, but then getting the historic value to sum and display in the same line is proving difficult. I’ve tried filtering the block to live qtys only, which is required and then displaying the historic values with a “no filter” sum but isn’t working. Any help would be much appreciated. Please see image and if statement below. Essentially I want 26 in the historic qty column.
=If(ToDate([Order Date];“dd/MM/yyyy”)>
ToDate(RelativeDate(CurrentDate();+3);“dd/MM/yyyy”) And
ToDate([Create Date];“dd/MM/yyyy”)<
ToDate(RelativeDate(CurrentDate();-7);“dd/MM/yyyy”)) Then “Live” Else “Hist”
