Hi @UserID16644
Conditional formula is a bit tricky in JMP.
As @jthi mentioned, you need 2 IFs.
You can also add formula column as below;
-Add 1st IF = column sum if code not 0
![WebDesignesCrow_1-1712029275306.png WebDesignesCrow_1-1712029275306.png](https://community.jmp.com/t5/image/serverpage/image-id/62961i135A2DA9C0D32639/image-size/medium?v=v2&px=400)
-Add 2nd IF = display result only if code not 0
![WebDesignesCrow_2-1712029413039.png WebDesignesCrow_2-1712029413039.png](https://community.jmp.com/t5/image/serverpage/image-id/62962iD3FE9D5C6117ACA7/image-size/medium?v=v2&px=400)
Result:
![WebDesignesCrow_3-1712029497725.png WebDesignesCrow_3-1712029497725.png](https://community.jmp.com/t5/image/serverpage/image-id/62963iAAA1200AEFDC94D6/image-size/medium?v=v2&px=400)
JSL Script (refer workflow builder / log)
Names Default To Here( 1 );
//Change column info: Total % (Col Sum Qty/Total Count)
Data Table( "dt1" ):Column 4 << Set Name( "Total % (Col Sum Qty/Total Count)" )
<< Set Formula(
If( !:Code == 0,
Col Sum( If( !:Code == 0, :Qty, . ) ) / :Total Count
)
);
//Change column format: Total % (Col Sum Qty/Total Count)
Data Table( "dt1" ):"Total % (Col Sum Qty/Total Count)"n <<
Format( "Percent", 12, 2 );