Question about formulas

forum.reportbuilder (2000-2005) & forum.td.reportbuilder (2005-2010)
Stefan van Hest

Question about formulas

Post by Stefan van Hest » 07 Dec 2007, 12:54

 Posted by:  Stefan van Hest 

Hello,

We use Gupta Report Builder 4.2

I need to build a formula that sums all rows in the detailblock of which a
data item is between 30 and 60. Is this possible in the reportbuilder?

Grt. Stefan

Mirko
Italy
Posts: 983
Joined: 04 Apr 2017, 08:56
Location: Geneva

Question about formulas

Post by Mirko » 07 Dec 2007, 14:43

 Posted by:  Mirko BONANNO 

Yes you can !!!

If I understood correctly you want to sum an imput item (nMyMt) only when
another input (nMyVal) value is between 30 and 60

define a formula like this

NumberIFF( nMyVal-31 , 0 , 0 , NumberIFF( nMyVal-61 , nMyMt , 0 , 0 ) )

and name it as you like !( I called it ValueToSum( ))

and then define a Total that will sum ValueToSum( )

HTH
Mirko

Mirko
Italy
Posts: 983
Joined: 04 Apr 2017, 08:56
Location: Geneva

Question about formulas

Post by Mirko » 07 Dec 2007, 14:46

 Posted by:  Mirko BONANNO 

Sorry little mistake the formula should be

NumberIFF( nMyVal-29 , 0 , 0 , NumberIFF( nMyVal-61 , nMyMt , 0 , 0 ) )

ciao
Mirko

Return to “td.reportbuilder”

Who is online

Users browsing this forum: [Ccbot] and 0 guests