4 Replies Latest reply on Feb 6, 2019 2:40 AM by Mihai Constantinescu

# Summing Up Calculated Fields

Hi I have tried to sum the calculated fields but it did not give me the number I want. I want to sum the "number of hired" and "number of offers but decline". The answer should be 648. However when I create the calculated field number of offers did not return a number despite the calculation being valid.

I have attached the workbook.

Thanks!

Shinichiro Murakami

• ###### 1. Re: Summing Up Calculated Fields

Declines: {FIXED [Candidate] : SUM(IF [Offer but Decline]>0 THEN 1 else 0 END)} = 232

Offers: {FIXED [Candidate] : SUM(if [Hired]>0 then 1 else 0 END)} =416

Sum = 648

• ###### 2. Re: Summing Up Calculated Fields

Actually sorry, opening your workbook again I can see that you got same results... so not sure now I understand what you need and where the problem is.

• ###### 3. Re: Summing Up Calculated Fields

Hi, Daniel

you should sum your calculation in the aggration level like below

Hope this helps

ZZ

• ###### 4. Re: Summing Up Calculated Fields

Thanks ZZ , now I understand what he meant...yea, he can do that or [Number of Offers]+[Number of Declines] using the LOD calculations I posted as they are already aggregated.