Formula identifies number - returns #value in the end - why?

[Camel123]

Hi,

I have a long formula and have taken snapshots of the last steps in the evaluation chain:
https://imgur.com/a/5z2NzW3

The formula identifies the value I am looking for but in the end it returns #value error. Can I please have some guidance on how to solve this issue?

 

[Fluff]

What is the formula? It looks as though you are trying to add "" to a number which will cause the error.

 

[Camel123]

What is the formula? It looks as though you are trying to add "" to a number which will cause the error.

Thank you mate your hint solved my issue, I replaced:
=IFERROR(IF($D31=1;"";IF(AND(SUM($T31:$DK31)=0;GD$1>=$R$3;GD$1<EDATE($R$3;$O31));($S31-$E31)/$O31;SUM(SUMIFS($T31:$DK31;$T$1:$DK$1;"<"&GD$1;$T$1:$DK$1;">="&EDATE(GD$1;-$O31))/$O31;IF(AND(DATEVALUE(GD$6&"/1")>AGGREGATE(15;6;DATEVALUE($T$6:$DK$6&"/1")/($T31:$DK31<>"");1);DATEVALUE(GD$6&"/1")<=EDATE(AGGREGATE(15;6;DATEVALUE($T$6:$DK$6&"/1")/($T31:$DK31<>"");1);$O31));SUM($S31-$E31)/$O31;""))));"")

with

=IFERROR(IF($D31=1;"";IF(AND(SUM($T31:$DK31)=0;GD$1>=$R$3;GD$1<EDATE($R$3;$O31));($S31-$E31)/$O31;SUM(SUMIFS($T31:$DK31;$T$1:$DK$1;"<"&GD$1;$T$1:$DK$1;">="&EDATE(GD$1;-$O31))/$O31;IF(AND(DATEVALUE(GD$6&"/1")>AGGREGATE(15;6;DATEVALUE($T$6:$DK$6&"/1")/($T31:$DK31<>"");1);DATEVALUE(GD$6&"/1")<=EDATE(AGGREGATE(15;6;DATEVALUE($T$6:$DK$6&"/1")/($T31:$DK31<>"");1);$O31));SUM($S31-$E31)/$O31;"0"))));"")

 

[Fluff]

Glad you sorted it & thanks for the feedback