total select lines

[Bill Steer]

thanks everyone !  works great !

Bill Steer
Pioneer CEP
10640 Springdale ave
Santa Fe Springs Ca 90670
bill.steer at pioneercep.com<mailto:bill.steer at pioneercep.com> (encouraged)
ph (562) 944-0626 #125 (discouraged)
fx (562) 944-1902  (pretty old school)
video skype great2b1 (email / call for me to turn on)
Map<http://goo.gl/maps/u8jml>  or  Pioneer Website<http://picometal.com>






On Dec 27, 2013, at 12:45 PM, dlh <rdoxies at cox.net<mailto:rdoxies at cox.net>> wrote:

Total sum value of the specified column in the list. Boolean parameter allows you to specified selected lines only. Default is 'kFalse'.

     ;  Total of the values in a column of the list.
     Calculate Total as List.$cols.ColName.$total()

     ;  You can add the parameter kTrue to include selected lines only.

     ;  Total value of the values in a column of the list, selected lines only.
     Calculate Total as List.$cols.ColName.$total(kTrue)     ;; (Selected lines)

Use '$totc' to find the total number of selected lines in list.

     ;  Number of selected lines in a list.
     Calculate %N as List.$totc(#LSEL)
On Dec 27, 2013, at 10:24 AM, Bill Steer <bill.steer at pioneercep.com<mailto:bill.steer at pioneercep.com>> wrote:

HI all,  happy holidays..

Can someone give me a hint on how to total selected lines,  something like tot(qty*$selected)  ?

thanks !


Bill Steer
Pioneer CEP






_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com