This discussion is archived
1 Reply Latest reply: Feb 5, 2013 3:42 AM by Ben Rogers RSS

Excel uncertainty for text attributes

865068 Newbie
Currently Being Moderated
I'm trying to evaluate a text attribute in an excel spreadsheet to <uncertain>. If I type uncertain into the "else" clause of the table then I get uncertain come through as a text value - not the OPA reserved useage of <uncertain> in the debugger. Is there a way around this? If the same rule is modelled in a Word table it works okay but I really want to use Excel.

  • 1. Re: Excel uncertainty for text attributes
    Ben Rogers Journeyer
    Currently Being Moderated
    I recreated the behaviour too. There may be a better workaround but I checked and this one definitely works.

    In a Word document (a system rule doc somewhere) create the following rule table:

    the uncertain text attribute
    uncertain | the current date > 2000-01-01
    uncertain | otherwise

    Declare the uncertain text attribute as a text.
    This is guaranteed to be always uncertain.

    Then in your Excel Else row, write the following (the uncertain text attribute)
    The brackets are used to reference the attribute name explicitly.

    Hope this helps.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points