Here's my query:
%SEARCH{type="query" "RequirementsForm" excludetopic="NewRequirementTemplate" nosearch="on" format="| [[$topic][$formfield(Name)]] | $formfield(ReadershipImpact) | $formfield(RevenueImpact) | $percntCALC{$SUM(R$ROW(0):C$COLUMN(-2)..R$ROW(0):C$COLUMN(-1))}$percnt | $formfield(BusinessPriority) | $formfield(ProgrammingComplexity) | $summary |" }%
Would be much nicer to write:
%SEARCH{type="query" "RequirementsForm" excludetopic="NewRequirementTemplate" nosearch="on" format="| [[$topic][$formfield(Name)]] | $formfield(ReadershipImpact) | $formfield(RevenueImpact) | $percntCALC{$SUM($formfield(RevenueImpact) +$formfield(ReadershipImpact))}$percnt | $formfield(BusinessPriority) | $formfield(ProgrammingComplexity) | $summary |" }%
or
%SEARCH{type="query" "RequirementsForm" excludetopic="NewRequirementTemplate" nosearch="on" format="| [[$topic][$formfield(Name)]] | $formfield(ReadershipImpact) | $formfield(RevenueImpact) | $CALC{$SUM($formfield(RevenueImpact) +$formfield(ReadershipImpact))}$$ | $formfield(BusinessPriority) | $formfield(ProgrammingComplexity) | $summary |" }%
[6:26pm] PeterThoeny__: $percntCALC{$SUM($formfield(RevenueImpact), $formfield(ReadershipImpact))}$percnt should be possible
http://koala.ilog.fr/twikiirc/bin/irclogger_log/twiki?date=2008-09-02,Tue
--
TWiki:Main.MartinCleaver - 02 Sep 2008
No enhancement necessary, you can put a $formfield() inside a CALC formula.
--
TWiki:Main.PeterThoeny - 24 Mar 2009