topic Re: want to count Base WOrk Output where SubStringCount =0 and QTY FA = 'N/A' .Table Summary in App Development

want to count Base WOrk Output where SubStringCount =0 and QTY FA = 'N/A' .Table Summary

Sxbbb — Fri, 15 Nov 2024 21:02:03 GMT

I Have Data

Machine FA :

Machine Runlot :

column "Base WOrk Output" is the field "WorkOrder_BaseOutput".

I want to count Base WOrk Output where SubStringCount =0 and QTY FA = 'N/A' .Table Summary

I tried and the value is incorrect.

Both codes are the same, incorrect.

want to count Base WOrk Output where SubStringCount =0 and QTY FA = 'N/A' .Table Summary

Nagaraju_KCS — Tue, 12 Mar 2024 05:39:29 GMT

if you have two fields in same table, calculate substringcount script level.

your expression will be like

COUNT({<SubstringCount={0}, QTY FA = {'N/A'}>}WorkOrder_Baseoutput)

Sxbbb — Tue, 12 Mar 2024 07:22:27 GMT

Error Expression

Nagaraju_KCS — Tue, 12 Mar 2024 07:41:10 GMT

QTY FA should be in SQUARE bracket [QTY FA]

Sxbbb — Tue, 12 Mar 2024 07:50:31 GMT

It counts every Base WORK Output, it is incorrect.

Just want to count (SubStringCount([Machine FA],[Machine Runlot])) = 0

Nagaraju_KCS — Tue, 12 Mar 2024 08:12:10 GMT

can you share sample data ?

Dataintellinalytics — Fri, 15 Mar 2024 12:49:00 GMT

As suggested by "Qv_testing" did you move the substring logic to backend data load editor script and created calculated field SubstringCount ?