Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Formula in table

I have a table that I created in a personal stationary. What i'd like to do is simply have a formula in a gross margin cell so it automatically calculates the GM%. I labeled and id each cell in my table. Formula is simply SALES - COST / SALES. Also trying to figure out how to have a cell have a currency value so when I type in a number it automatically has a dollar sign and two decimals. Sort of like the format option in excel.
0
goingolfn99
Asked:
goingolfn99
  • 2
2 Solutions
 
SysExpertCommented:
I am not sure if this will be easy without having access to a Design client.

If you do have access, please let us know.

I hope this helps !
0
 
qwaleteeCommented:
You can't do calculations or number formatting in Lotus Notes stationery.  You need to either have a custom-deisgned form, or use an embedded spreadsheet.
0
 
goingolfn99Author Commented:
I guess that's okay but why is there a Formula Window in the text properties
0
 
qwaleteeCommented:
The only formula window in the proeprties is associated with Hide When formulas, which has nothing to do with what you are trying.  (IMHO, Lotus screwed up by exposing this to begin with.)
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now