[teholmbe]

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.

[benvanderbeek]

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