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

Outcomes