I'm selecting a list of items from a portal and the conditions is that the items needs to be current so the "Active" items are generated by this condition:
If ( ( Year_Num & Month_Num ) ≥ ( Year ( Get ( CurrentDate ) ) & Right ( 0 & Month ( Get ( CurrentDate ) ); 2 ) ) ; "Active" ; "" )
& ¶ &
Now I also want to include on the condition that if the item is sold out it shouldn't display.
Meaning if "Remaining Items" are = 0 don't show them in Active.
How can you modify the rule? I've tried multiple things but the results are less than stellar