How can I multiply if the custom expression contains keyword with in the formula

I am trying to achieve a calculation in Spotfire. Where I am trying below expression but its giving me a different result.

 

formula:

Sum(case when [wip]=1 then 1 else 0 end) / Sum((case when [fpassed]=1 then 1 else 0 end) * 1.0) * 0.85) + ( Sum(case when [recover]=1 then 1 else 0 end) / Sum((case when [fpassed]=1 then 1 else 0 end) * 1.0) * (Sum(case when [fpassed]=1 then 1 else 0 end) / Sum((case when [total_input]=1 then 1 else 0 end) * 1.0))) as [PROJECTED YIELD]

RESULT before combining into one.

VALUES: 88.73= Sum(case when [wip]=1 then 1 else 0 end) / Sum((case when [mlb_passed]=1 then 1 else 0 end) * 1.0) * 0.85) + ( Sum(case when [fg_recovery]=1 then 1 else 0 end) / Sum((case when [mlb_passed]=1 then 1 else 0 end) * 1.0)

54.03 = Sum(case when [fpassed]=1 then 1 else 0 end) / Sum((case when [total_input]=1 then 1 else 0 end) * 1.0))

47.9 should be the projected yield but the result coming from the calculation is 49.0

 

 

THank you in advance

(1) Answer

Login