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 602 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: 21562
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.
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.
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: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What about the documentation?
LAG/LEAD

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


Current Time: Tue Jun 02 04:05:26 CDT 2020