Formula Error

[ktitler]

Hello,

 

I am trying to add a formula to my table, and I keep getting the following error: "Unable to save table due to incompatible values in one or more formula fields."

Formula:

([@field:Elig_Reg_Riders]+[@field:Elig_Spec_Need_Riders])/([@field:Regular_Runs]+[@field:SPED_Runs])

All four of the fields have Number DataType, so I am not sure why I am getting this error. Can you please help?

[MayMusic]

Make sure you are not getting 0 by this statement:  ([@field:Regular_Runs]+[@field:SPED_Runs])  as division by 0 is not allowed. Try to change your formula to :

 

([@field:Elig_Reg_Riders]+[@field:Elig_Spec_Need_Riders])/(CASE WHEN ([@field:Regular_Runs]+[@field:SPED_Runs])  = 0 THEN 1 ELSE  ([@field:Regular_Runs]+[@field:SPED_Runs])  END)

 

[Glitch]

Hi there, that's correct. the reason why it's returning an error is if you have 0 on the division. You can just add a NULLIF to your statement. 

 

You can use this formula:

([@field:Elig_Reg_Riders]+[@field:Elig_Spec_Need_Riders])/NULLIF(([@field:Regular_Runs]+[@field:SPED_Runs]),0)

 

Let me know if this works.