Formula diferent result
Fred
Hi the Cantidad Doc in the Formula is not the same on Table and Form 
if Clase = "Actividad" then
cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = "Actividad")
else
if Clase = "Documento" then
cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = "Documento")
else
if Clase = "Plano" then
cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = "Plano")
end
end
end
7 replies
-
if you click on the refresh button (above the Id number in Table view) does it change?
-
Fred
, just at the same time.
-
-
Is Clase a formula?
The code can be shortened, Can you try this plz :
let cla := text(Clase); cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = cla) -
RoSoft_Steven Rooryck
Hi again Steven I have the same problem with these Formula work in Form but not in Table
cnt(select DOCUMENTOS where 'Ganado REAL' = 30)
Count the Documents where Ganado REAL is 30
I have six Formula witn null,30,50,70,100
-
Rafael
'Ganado REAL' is a formula field that displays % so you could use this:
cnt(select DOCUMENTOS where number('Ganado REAL') = 30)
Hope this helps.
-
RoSoft_Steven Rooryck Thanks again.
-
Content aside
- Status Answered
- 2 yrs agoLast active
- 7Replies
- 50Views
-
3
Following