Home » Developer & Programmer » Forms » Like MS Excel Formula (forms 6i and 11g)
Like MS Excel Formula [message #659639] Wed, 25 January 2017 04:47 Go to next message
zaibi
Messages: 17
Registered: January 2017
Junior Member
Hi experts i need formula.

:balance:=(:Balance(Previous_record)-:debit(current record))+credit(current record);

[EDITED by LF: removed useless formatting]

/forum/fa/13425/0/

[mod-edit: image inserted into message body by bb]
  • Attachment: 2.jpg
    (Size: 76.52KB, Downloaded 2699 times)

[Updated on: Fri, 27 January 2017 16:29] by Moderator

Report message to a moderator

Re: Like MS Excel Formula [message #659640 is a reply to message #659639] Wed, 25 January 2017 04:54 Go to previous messageGo to next message
Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check LAG and LEAD functions. Note that your ancient Forms 6i might not use these functions, so you'll have to create a stored function (or a view) in the database and use it in a form.

Report message to a moderator

Re: Like MS Excel Formula [message #659641 is a reply to message #659640] Wed, 25 January 2017 05:03 Go to previous messageGo to next message
zaibi
Messages: 17
Registered: January 2017
Junior Member
What is lag and lead functions and how it work. and i want this working in forms 6i how can i perform this working.

Report message to a moderator

Re: Like MS Excel Formula [message #659642 is a reply to message #659641] Wed, 25 January 2017 06:42 Go to previous message
Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

What about the documentation?
LAG/LEAD

Report message to a moderator

Previous Topic: Master/Detail Relationships Selects CHECK BOX
Next Topic: How to dynamically center a canvas
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 05 21:46:28 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.