---++ !!Test of Adding Totals to Activity List for MikeStraka

%CALC{$SET(thisweek,$FORMATTIME($TIMEADD($TIME(%DATE%),-$MOD($EVAL(($FORMATTIME($TIME(%DATE%),$wd)-2)+7),7),day),$day $mon $year))}%


%BR%
---+++ Output With !WeekOf Hardcoded as '09 Nov 2009'

<div style="font-size: 8pt;" >
%TABLE{ %TRACKERCOLHEADINGATTRIBUTES% columnwidths="70,30,,160,70,70" dataalign="center,center,left,left,right,right" initsort="3" footerrows="1" }%
| *Week Of* | *Edit* | *Activity* | *Resource* | *Estimated Effort (Days)* | *Actual Effort (Days)* |
%SEARCH{ type="query" web="%WEB%" nosearch="on" nototal="on" "form.name='ActivityForm' AND (ResourceName='MikeStraka' OR ResourceName/(ResourceForm[name='ResourceManagerName'].value='MikeStraka')) AND WeekOf='09 Nov 2009'" format="| $formfield(WeekOf) | [[%SCRIPTURLPATH{"edit"}%/%WEB%/$topic?t=%GMTIME{"$epoch"}%;nowysiwyg=1&action=form&redirectto=%SCRIPTURL{"view"}%/%WEB%/%INCLUDINGTOPIC%?pane1tab=4&pane2tab=1][ $percntICON{edittopic}$percnt ]] | [[$topic][$percntFORMFIELD{$quotCustomerName$quot topic=$quot$formfield(CustomerId)$quot}$percnt $percntFORMFIELD{$quotOpportunityTitle$quot topic=$quot$formfield(OpportunityId)$quot}$percnt: $formfield(ActivityName)]] | $formfield(ResourceName) | $formfield(EstimatedEffort) | $formfield(ActualEffort) |"}%
| ROW=%CALC{$ROW()}% | | ABOVE=%CALC{$ABOVE()}% |  <b>Total:</b> | %CALC{$FORMAT(COMMA,1,$SUM($ABOVE()))}% d | %CALC{$FORMAT(COMMA,1,$SUM($ABOVE()))}% d |
</div>


%BR%
---+++ Output With !WeekOf Evaluated as Result of a CALC{} Operation

<div style="font-size: 8pt;" >
%TABLE{ %TRACKERCOLHEADINGATTRIBUTES% columnwidths="70,30,,160,70,70" dataalign="center,center,left,left,right,right" initsort="3" footerrows="1" }%
| *Week Of* | *Edit* | *Activity* | *Resource* | *Estimated Effort (Days)* | *Actual Effort (Days)* |
%SEARCH{ type="query" web="%WEB%" nosearch="on" nototal="on" "form.name='ActivityForm' AND (ResourceName='MikeStraka' OR ResourceName/(ResourceForm[name='ResourceManagerName'].value='MikeStraka')) AND WeekOf='%CALC{$GET(thisweek)}%'" format="| $formfield(WeekOf) | [[%SCRIPTURLPATH{"edit"}%/%WEB%/$topic?t=%GMTIME{"$epoch"}%;nowysiwyg=1&action=form&redirectto=%SCRIPTURL{"view"}%/%WEB%/%INCLUDINGTOPIC%?pane1tab=4&pane2tab=1][ $percntICON{edittopic}$percnt ]] | [[$topic][$percntFORMFIELD{$quotCustomerName$quot topic=$quot$formfield(CustomerId)$quot}$percnt $percntFORMFIELD{$quotOpportunityTitle$quot topic=$quot$formfield(OpportunityId)$quot}$percnt: $formfield(ActivityName)]] | $formfield(ResourceName) | $formfield(EstimatedEffort) | $formfield(ActualEffort) |"}%
| ROW=%CALC{$ROW()}% | | ABOVE=%CALC{$ABOVE()}% |  <b>Total:</b> | %CALC{$FORMAT(COMMA,1,$SUM($ABOVE()))}% d | %CALC{$FORMAT(COMMA,1,$SUM($ABOVE()))}% d |
</div>


---+++ Output With !WeekOf Evaluated as Result of a CALC{} Operation with conditional formatting

<div style="font-size: 8pt;" >
%TABLE{ %TRACKERCOLHEADINGATTRIBUTES% columnwidths="70,30,,160,70,70" dataalign="center,center,left,left,right,right" initsort="3" footerrows="1" }%
| *Week Of* | *Edit* | *Activity* | *Resource* | *Estimated Effort (Days)* | *Actual Effort (Days)* |
%SEARCH{ type="query" web="%WEB%" nosearch="on" nototal="on" "form.name='ActivityForm' AND (ResourceName='MikeStraka' OR ResourceName/(ResourceForm[name='ResourceManagerName'].value='MikeStraka'))" format="$percntCALC{$IF($EXACT($GET(thisweek),$formfield(WeekOf))==1,| $formfield(WeekOf) | [[%SCRIPTURLPATH{"edit"}%/%WEB%/$topic?t=%GMTIME{"$epoch"}%;nowysiwyg=1&action=form&redirectto=%SCRIPTURL{"view"}%/%WEB%/%INCLUDINGTOPIC%?pane1tab=4&pane2tab=1][ $percntICON{edittopic}$percnt ]] | [[$topic][$percntFORMFIELD{$quotCustomerName$quot topic=$quot$formfield(CustomerId)$quot}$percnt $percntFORMFIELD{$quotOpportunityTitle$quot topic=$quot$formfield(OpportunityId)$quot}$percnt: $formfield(ActivityName)]] | $formfield(ResourceName) | $formfield(EstimatedEffort) | $formfield(ActualEffort) |,<nop>)}$percnt"}%
| ROW=%CALC{$ROW()}% | | ABOVE=%CALC{$ABOVE()}% |  <b>Total:</b> | %CALC{$FORMAT(COMMA,1,$SUM($ABOVE()))}% d | %CALC{$FORMAT(COMMA,1,$SUM($ABOVE()))}% d |
</div>