Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
help with the below set analysis. i'm looking for the qty for the max date, less than or equal to the user defined date. i'm using a end date variable as the user defined date.
the qvw doesn't seem to like the second {, its red underlined.
sum ({$<max(inv_cal_dt)={$(=$(EndDate))
Thanks,
Sara
I was given this, and it works!!
FirstSortedValue({$<inv_cal_dt={"<=$(EndDate)"}>} oh_qty, -inv_cal_dt)
SUM({<inv_cal_dt={$(=Max(EndDate))}>}VALOR)
tried this, did not work. it still doesnt like the second {
sum
({$<max(inv_cal_dt)={$(=$(EndDate))}>}oh_qty
I do not think you can use max() in the first part of set analysis. I believe it needs to be a field.
You can set this as a new field in the script using a resident load with a group by function.
I was given this, and it works!!
FirstSortedValue({$<inv_cal_dt={"<=$(EndDate)"}>} oh_qty, -inv_cal_dt)