Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm trying to create a set analysis equivalent to this expression that I use in a pivot table's expression column:
SUM(
IF
(
ISSUE_DATE >= SHIPMENT_DATE
AND ISSUE_DATE < NEXT_SHIPMENT_DATE
AND CHECKED_SHIPMENTS=1,
SHIPMENT_VALUE
)
)
I've already checked through community a lot but so far I could only found set analysis solutions with variables.
Since I'm not very familiar with set analysis syntax, I couldn't manage to create a working expression.
The expression above works fine but I want to write it as a set analysis expression due to better performance.
In my case ISSUE_DATE, SHIPMENT_DATE and NEXT_SHIPMENT_DATE fields are all in the same date format.
I'd appreciate any help.
Thanks in advance,
May be something along these lines:
Sum({<ORDERID = {"=ISSUE_DATE >= SHIPMENT_DATE and ISSUE_DATE < NEXT_SHIPMENT_DATE"}, CHECKED_SHIPMENTS = {1}>}SHIPMENT_VALUE)
Replace ORDERID with a field which is unique for a particular combination of ISSUE_DATE, SHIPMENT_DATE and NEXT_SHIPMENT_DATE.