AnsweredAssumed Answered

Calculation question...

Question asked by JodieWeston on Feb 5, 2018
Latest reply on Feb 5, 2018 by JodieWeston

Help, please...


I would like to create a field that calculates as below:


If the 'Active' field is checked,

and the 'Net Costs' field contains a value

I would like the 'New' field to display a total of 'Net Costs' divided by 'Total boxes'


Example 1.

'Active' - Yes

'Net Costs' - $300

'Total boxes' - 3

'New' - $100


Example 2.

'Active' - Yes

'Net Costs' - $600

'Total boxes' - 1

'New' - $600


I would very much appreciate any help