Item5978: WIBNIF: CALC knew about formfield values and could use them in calculations

pencil
Priority: Enhancement
Current State: Confirmed
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: SpreadSheetPlugin
Branches:
Reported By: TWiki:Main.MartinCleaver
Waiting For:
Last Change By: GeorgeClark

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

ItemTemplate edit

Summary WIBNIF: CALC knew about formfield values and could use them in calculations
ReportedBy TWiki:Main.MartinCleaver
Codebase
SVN Range TWiki-5.0.0, Mon, 18 Aug 2008, build 17431
AppliesTo Extension
Component SpreadSheetPlugin
Priority Enhancement
CurrentState Confirmed
WaitingFor
Checkins
TargetRelease n/a
ReleasedIn n/a
CheckinsOnBranches
trunkCheckins
masterCheckins
ItemBranchCheckins
Release01x01Checkins
Topic revision: r3 - 04 Jan 2015, GeorgeClark - This page was cached on 21 Feb 2019 - 07:42.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy