Home » Developer & Programmer » Forms » calculation mode with conditions (forms 10g)
calculation mode with conditions [message #596573] Tue, 24 September 2013 16:27 Go to next message
tigerbelal
Messages: 2
Registered: April 2009
Location: Egypt
Junior Member
Dear All

I have 2 feilds f1,f2

I define f1 a summary in calculation mode

I want to sum f1 where f2 = 5

thanks

Report message to a moderator

Re: calculation mode with conditions [message #596580 is a reply to message #596573] Wed, 25 September 2013 00:18 Go to previous messageGo to next message
tigerbelal
Messages: 2
Registered: April 2009
Location: Egypt
Junior Member

I want to calculate the SUM of column f1 where f2=5 in forms before save in DB

[Updated on: Wed, 05 March 2014 01:00] by Moderator

Report message to a moderator

Re: calculation mode with conditions [message #596699 is a reply to message #596580] Wed, 25 September 2013 13:05 Go to previous message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'll have to write some code to do that (looping through all block records). Forms can't calculate that itself because you can't specify condition in item's property palette.

Report message to a moderator

Previous Topic: Edit and Save image Item
Next Topic: Chatting Application
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 01:00:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.