https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/84041.aspxWed, 31 Oct 2012 03:16:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:84041Joey_860https://www.infopathdev.com:443/forums/thread/84041.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=84041<p>Hi All,</p> <p>I&#39;m just having a bit of trouble creating a calculated column query for what I need, basically I have the following columns:</p> <p>- &#39;Current Status&#39; with the following selections:- In Progress, On Hold, Complete &amp; Withdrawn/Rejected</p> <p>- &#39;Target Age&#39;: This is a calculated column which calculates the number of days between the created and target date of an item which also includes negative numbers (</p> <p>- &#39;Overdue&#39;: This is also a calculated column identifying the following &#39;IF([Target Date]=&quot;&quot;,&quot;Blank&quot;,IF([Target Date]&lt;=Today,&quot;Yes&quot;,IF([Target Date]&gt;=Today,&quot;No&quot;)))&#39;</p> <p>- &#39;Status Indicator&#39;: This is the calculated I&#39;m having issues with which will display a HTML&nbsp;image marker&nbsp;based on the IF statements</p> <p>Now this is the problem I&#39;m having, I need the following scenario&#39;s built into the IF statement for the calculated column</p> <p>- If the &#39;Current Status&#39; = &#39;In Progress&#39; &amp; &#39;Overdue&#39; = &#39;No&#39; (Green Marker)</p> <p>- If the &#39;Current Status&#39; = &#39;Complete&#39; &amp; &#39;Overdue&#39; = &#39;No&#39; (Green Marker)&nbsp;&nbsp;</p> <p>- If the &#39;Current Status&#39; = &#39;On Hold&#39; &amp; &#39;Overdue&#39; = &#39;Yes&#39; (Yellow Marker)</p> <p>- If the &#39;Current Status&#39; = &#39;On Hold&#39; &amp; &#39;Overdue&#39; = &#39;Blank&#39; (Yellow Marker)</p> <p>- If the &#39;Current Status&#39; = &#39;In Progress&#39; &amp; &#39;Overdue&#39; = &#39;Yes&#39; &amp; &#39;Target Age&#39; &lt; 0 (Red Marker)</p> <p>- If the &#39;Current Status&#39; = &#39;In Progress&#39; &amp; &#39;Overdue&#39; = &#39;Blank&#39; &amp; &#39;Target Age&#39; &lt; 0 (Red Marker)</p> <p>- If the &#39;Current Status&#39; = &#39;Withdrawn/Rejected&#39; &amp; &#39;Overdue&#39; = &#39;Yes&#39; (Grey Marker)</p> <p>- If the &#39;Current Status&#39; = &#39;Withdrawn/Rejected&#39; &amp; &#39;Overdue&#39; = &#39;Blank&#39; (Grey Marker)</p> <p>&nbsp;This is what I have tried already but hasn&#39;t seemed to work for the test items I specified: &#39;IF([Current Status]=&quot;In Progress&quot;,IF([Overdue]=&quot;No&quot;,&quot;&lt;DIV&gt;&lt;IMG SRC=&#39;/Pictures/Marker/green.png&#39;&gt;&lt;/DIV&gt;&quot;,IF([Current Status]=&quot;On Hold&quot;,IF([Overdue]=&quot;Yes&quot;,&quot;&lt;DIV&gt;&lt;IMG SRC=&#39;/Pictures/Marker/yellow.png&#39;&gt;&lt;/DIV&gt;&quot;,IF([Current Status]=&quot;On Hold&quot;,IF([Overdue]=&quot;Blank&quot;,&quot;&lt;DIV&gt;&lt;IMG SRC=&#39;/Pictures/Marker/yellow.png&#39;&gt;&lt;/DIV&gt;&quot;,IF([Overdue]=&quot;Yes&quot;,&quot;&lt;DIV&gt;&lt;IMG SRC=&#39;/Pictures/Marker/red.png&#39;&gt;&lt;/DIV&gt;&quot;))))</p>