I want to calculate Defect that Input must not be 0.

[Sxbbb]

I want to calculate Defect that Input must not be 0.

I tried the code : (if( Not IsNull(( Input_SQFT)),Sum(Defect_SQFT)))

But the values ​​are not shown in the Summary table.

I want the value 104.6896 to show in the Summary table.

I want to calculate Defect that Input must not be 0.

[Sxbbb]

I want to calculate Defect that Input must not be 0.

I tried the code : (if( Not IsNull(( Input_SQFT)),Sum(Defect_SQFT)))

But the values ​​are not shown in the Summary table.

I want the value 104.6896 to show in the Summary table.

I want to calculate Defect that Input must not be 0.

[rubenmarin · Accepted solution]

Hi, you can try with: Sum({<Input_SQFT={"*"}>} Defect_SQFT)

[BrunPierre]

This could as well be a solution.

Sum({$<Input_SQFT={"=Len(Input_SQFT)>0"}>} Defect_SQFT)

[Sxbbb]

thank you very much