Thanks makes sense... I think I did this by doing a HOLD FILE or two.
December 10, 2018, 10:27 AM
After more thought on this, it's not "[SOLVED]". Here's the deal,
1) I need to get the shipping status at a summary level, only three statuses: 'Shipped', 'Not Shipped', and 'Partial', based on the status of multiple ORDERS for multiple PROJECTS. I was using the following code, based on the 'users documentation'.
Shipped_Status/A11=IF SHIP_STATUS NE 'Active' THEN 'Shipped'
ELSE IF SHIP_STATUS EQ 'Active' AND QTY_OPEN EQ 0 THEN 'Not Shipped'
ELSE IF SHIP_STATUS EQ 'Active' AND QTY_OPEN NE 0 THEN 'Partial' ;
-*'QTY_OPEN EQ 0' means that there are no more items to be shipped for this ORDER.
That's NOT working... Here's the user's Tableau code. They're referring to this as an "LOD Expression":
-* IF SHIP_STATUS="ACTIVE" THEN
-* IF QTY_OPEN=0 THEN 1 ELSE 0 END
-* ELSE 1 END
December 10, 2018, 10:46 AM
Doesn't the last THEN need an ELSE?
WebFOCUS 8206, Unix, Windows
December 10, 2018, 11:26 AM
Oh My... I haven't forgotten an ELSE in a long time. Now that clock just got reset...
However, it didn't change the result as all the scenarios were covered.
December 11, 2018, 08:53 AM
Can SHIP_STATUS or QTY_OPEN ever be NULL?
WF 8.2.06 Win10 / IE11 AHTML EXL2K PDF
December 11, 2018, 09:19 AM
Good question. But, Nope. I just verified that.
December 19, 2018, 01:09 PM
FP Mod Chuck
If this is still an open issue for you you may want to open a case with techsupport..
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 20, 2018, 09:11 AM
Not really an issue anymore. I closed it.
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Most recent: 8204 Gen 48 in Test and Production. Currently Available. Please contact me.