3 Replies Latest reply: Oct 1, 2010 8:28 PM by John Witherspoon RSS

    Expressions in Chart Properties


      I have a CheckYN flag Expression in a Straight Table chart. This flag compares two date fields (the date fields are being pulled in from two different tables) and assigning a "Yes" or a "No". This part works fine. Now, I only want to see the "Yes" records in my application. This part is not working.

      How can I get just the "Yes" items to show? I've tried using the Presentation tab, selecting my Expression name (CheckYN Flag) and selecting the Conditional setting and in the conditional putting the formula: ='Yes' but that does not work. Am I simply using the wrong syntax for the formula or is there something else I need to do?

      Any help would be greatly appreciated! Thanks.