This topic contains 1 reply, has 0 voices, and was last updated by benvanderbeek 6 years, 5 months ago.

  • Author
    Posts
  • #22494 Score: 0

    teholmbe
    • Contributions: 0
    • Level 1

    Hi,

    I need to make a rather simple calculation between two columns having values created with Summary Type 'Sum'. See picture below.

    I'd like to make calculation to a new column in a way : (B-D)/(A-C)

    Can I some how refer to a column or can I make it in a single Formula

    Thanks,

    Tomi
    This is a cached copy. Click here to see the original post.

  • #22495 Score: 0

    benvanderbeek
    • Contributions: 0
    • Level 1

    Have you tried using the SQL SUM() formula to do what you're describing? I believe if there's such an aggregate function in the formula, NetSuite may ignore the function in the Summary Type column. I've successfully performed calculations using different summary functions inside formulas.

You must be logged in to reply to this topic.