DECIMAL Expression

kdunn
Participant I

Hi. Can someone tell me what is wrong with the below expression? I keep getting this error “Arithmetic expression ‘([Used] > 0)’ does not have valid input types”

IF(AND([Used]>0, [Have not used]>0), ([Used]/([Used]+[Have not used]))*100.00, 0)

Solved Solved
0 4 271
1 ACCEPTED SOLUTION

You all are so super smart. I just looked and it was set to text. I changed it to decimal and all fixed. Thanks so much!

View solution in original post

4 REPLIES 4

Could you please mention the column types for columns [Used] and [Have Not Used]

You all are so super smart. I just looked and it was set to text. I changed it to decimal and all fixed. Thanks so much!

Hi @Suvrutt_Gurjar see screen shot below

Could you please elaborate on why i keep getting NaN for this. the number is portrayed as the following

17021118.6041.403410

This is what i need to show.

I believe your content of “Secondary Code” is not in decimal number format because it has two decimal points at two different places.

I presume you are not using this content in any mathematical expression.

If so , please try to make that column in the child table and the same column that you have referenced from the parent table as text type.

Edit: NaN means “Not a Number”

Top Labels in this Space