Forums › Cached › Customization › Searches / List Views

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

  • Author
    Posts
  • May 15, 2018 at 2:38 pm #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.

  • May 16, 2018 at 9:03 am #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.

  • Author
    Posts

You must be logged in to reply to this topic.