• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
Does this site look broken?. Use the LitterTray web for test cases.

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

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Extension SpreadSheetPlugin Enhancement No Action Required   n/a  

Edit Form Data

Summary:
Reported By:
Codebase:
Applies To:
Component:
Priority:
Current State:
Waiting For:
Target Release:
Released In:
 

Detail

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

ItemTemplate
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 No Action Required
WaitingFor

Checkins

TargetRelease n/a
ReleasedIn

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2009-03-24 - PeterThoeny
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback