Formula in table

Posted on 2007-08-03
Last Modified: 2013-12-18
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.
Question by:goingolfn99
    LVL 63

    Accepted Solution

    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 !
    LVL 31

    Assisted Solution

    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.

    Author Comment

    I guess that's okay but why is there a Formula Window in the text properties
    LVL 31

    Expert Comment

    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.)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video discusses moving either the default database or any database to a new volume.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now