4 Replies Latest reply on Mar 6, 2017 1:40 PM by jtalbot

    Filemaker training Advanced Activity 23.2.  when setting up the calculation and pressing ok it comes back with cant find table for "total" in first case.

    jtalbot

      Let ( [

      rows = Count (order_LINEITEM::ID_LineItemID ) ;
total = Sum ( order_LINEITEM::Quantity ) ] ;

      "Order Details (" & rows &

      Case ( rows = 1 ; " item" ; " items" ) & " / " &

      total & Case ( total = 1 ; " piece)" ; " pieces)" )
)

       

      comes back with can't find Table for "total" under first Case.