Decimal column calculation zero "0.000" problem

AppSheet AppSheet Q&A
1

[Decimal1] = 0.000
[Decimal2] = 0.000
[Decimal3] = [Decimal1] * 10 / [Decimal2]

I have a calculation,

however, Decima1 and Decimal2 may not be available at all, but when “[Decimal3]” is not a value, it is calculated as “0.000”, how do I prevent it.

In summary I would like Decimal1 and Decimal2 to leave Decimal3 empty if there is no value

2

IFS(AND(ISNOTBLANK([Decimal1]), ISNOTBLANK([Decimal2])), [Decimal1]*10/[Decimal2],

OR(ISBLANK([Decimal1]), ISBLANK([Decimal2])), NUMBER(“”))

Solved. I wanted to share.

Thank you:)

4 Likes
3

IFS(AND(ISNOTBLANK([Decimal1]), ISNOTBLANK([Decimal2])), [Decimal1]*10/[Decimal2])

that’s enough, actually

2 Likes