FAVC96 Posted October 23, 2023 Report Share Posted October 23, 2023 I have a subquery: SELECT SUM(Requisicion_Importe) FROM Requisicion WHERE Requisicion_Contrato = target.[@field:Contrato_ID] That for some conditions doesnt find results, the problem is that is showing me empty spaces insted of 0 that i need for another calculated field. Right now i cant use that column because i have something like this 10 - " " = " " , insted of 10 - 0 = 10 Can you help me change my query with proteccion for isnull() Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted October 23, 2023 Report Share Posted October 23, 2023 Hello @FAVC96, It is possible to enclose the whole query in the isNull() function: IsNull((SELECT SUM(Requisicion_Importe) FROM Requisicion WHERE Requisicion_Contrato = target.[@field:Contrato_ID], 0) Quote Link to comment Share on other sites More sharing options...
0 telly Posted October 28, 2023 Report Share Posted October 28, 2023 Hi @FAVC96, I found this document to be helpful https://howto.caspio.com/function-reference/ Quote Link to comment Share on other sites More sharing options...
Question
FAVC96
I have a subquery:
SELECT SUM(Requisicion_Importe) FROM Requisicion
WHERE Requisicion_Contrato = target.[@field:Contrato_ID]
That for some conditions doesnt find results, the problem is that is showing me empty spaces insted of 0 that i need for another calculated field.
Right now i cant use that column because i have something like this 10 - " " = " " , insted of 10 - 0 = 10
Can you help me change my query with proteccion for isnull()
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.