AnsweredAssumed Answered

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.

Question asked by jtalbot on Mar 6, 2017
Latest reply on Mar 6, 2017 by 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.

Outcomes