topic Re: I want to calculate Defect that Input must not be 0. in App Development

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

Sxbbb — Fri, 15 Nov 2024 21:33:16 GMT

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 — Sat, 22 Jul 2023 07:18:28 GMT

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

BrunPierre — Sat, 22 Jul 2023 11:23:51 GMT

This could as well be a solution.

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

Sxbbb — Tue, 25 Jul 2023 06:54:17 GMT

thank you very much