Formula is not working when I divide smaller number with greater number

[Mushigee2266]

I have following two SQL formulas in formula fields

1. 

(SELECT COUNT (Master_Data_Auto_Short_Condition_Validation) FROM _v_Master_Data_Auto_Short_View

 WHERE Master_Data_Auto_Short_Category=Target.[@field:Master_Data_Auto_Short_Category] AND Master_Data_Auto_Short_Condition_Validation !="3" )

Its answer is 13

2. and second is 

(SELECT SUM (Master_Data_Auto_Short_Condition_Validation) FROM _v_Master_Data_Auto_Short_View

 WHERE Master_Data_Auto_Short_Category=Target.[@field:Master_Data_Auto_Short_Category] AND Master_Data_Auto_Short_Condition_Validation !="3")

It answer is 10

 

3. Now I am dividing serial 2 with serial 1 ( i.e, 10/13) but answer is 0 in caspio calculated fields.

 

These formulas give accurate answer when I divide with equal number. Otherwise answer is zero.

 

Please can anybody diagnose the problem

[Queso]

Hi @Mushigee2266,

It seems that the field you are using for Calculated Value/Field is an Integer data type. You can try a Virtual Field or change your actual field's data type into Number. Here is a similar forum post about your concern:

 

[Mushigee2266]

Thank you very much. It is working now.

[cheonsa]

Hello!

For more details about the different functions available in Caspio, you may check their article here:

https://howto.caspio.com/function-reference/