SUM Quantity Products = SUM rows ISNOTBLANK

[marinocity]

Hi,

I need your help to finish an app.
I've an inventory app with table VENTAS and table DETALLE_VENTAS (Child)

I need to compare that quantity of products = quantity of columns [SERIAL] ISNOTBLANK

Columns in table DETALLE_VENTAS:
[PART NUMBER]
[QUANTITY]
[SERIAL01]
[SERIAL02]
[SERIAL03]
[SERIAL04]
[SERIAL05]
[SUMSERIALS] Virtual Column type number / formula (wrong)

IFS( 
ISNOTBLANK([SERIAL01]),1 ,
ISNOTBLANK([SERIAL02]),1 ,
ISNOTBLANK([SERIAL03]),1 ,
ISNOTBLANK([SERIAL04]),1 ,
ISNOTBLANK([SERIAL05]),1 ,
ISBLANK([SERIAL01]),0 ,
ISBLANK([SERIAL02]),0 ,
ISBLANK([SERIAL03]),0 ,
ISBLANK([SERIAL04]),0 ,
ISBLANK([SERIAL05]),1 ,
)

Then another formular compare the SUM, but won't work.

SUM([Related DETALLE_VENTASs][QUANTITY]) =
SUM([Related DETALLE_VENTASs][SUMSERIALS])

Please, I need your help!
Thanks

[marinocity]

any help?

[marinocity]

Can you help me @Joseph_Seddik or @Kabuliño ?

[marinocity]

I don't understand how a post with 40 views doesn't even have a suggestion.

I've been on this forum for a while and I notice that many users are reluctant to help or give a suggestion. As if it bothers them to help others.

In my particular case, all my questions are with precise information, I try to formulate, always with specific doubts, never pretending that they solve everything for me.

I don't understand what sense there is in a collaborative forum if users feel bothered about helping others.

Except for some users, I feel disappointed with the Appsheet community, it discourages me to continue learning. a pity

 @preethamm 

-------------------------------------------

No entiendo como un post de 40 vistas no tiene ni siquiera una sugerencia.

Hace un tiempo estoy en este foro y noto que muchos usuarios son reticentes a ayudar o dar una sugerencia. Como si les molestara ayudar a los demas.

En mi caso particular, todas mis preguntas son con informacion precisa, intento de formulas, siempre con dudas puntuales, nunca pretendiendo que me resuelvan todo.

No entiendo que sentido tiene un foro de colaboracion si los usuarios se sienten molestos en ayudar a los demas.

Salvo algunos usuarios, me siento decepcionado con la comunidad de Appsheet, desanima seguir aprendiendo. Una pena