Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Calculations from a previous row.
11/12/2012
00:51
Avatar
brewsterjones@hotmail.com
New Member
Members
Forum Posts: 1
Member Since:
11/12/2012
sp_UserOfflineSmall Offline

To begin with… love the product!

Tougher question.  I need to add dates from a previous row and field. Example:

# Start Date Number Mos Event
1 1/2012 3 Payment
2 4/2012 6 Vacant
3 10/2012 1 Sold Item

I want row 2 to update the start date by adding 3 months to 1/2012 result of 4/2012 and then row 3 to update 6 months from 4/2012 etc etc.  A continuation from the previous date/data.  

Or maybe an easier way to ask the question, can you put formulas in the update or cell value kind of like excel.  
B3=B2+C2 and B4=B3+C3 etc etc.

I saw in other posts that it does not do any calculations... I can do the formulas for the data but how can I populate the update field or insert field with the data?

Any help or advice would be greatly appreciated.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 496

Currently Online:
22 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information