AnsweredAssumed Answered

NSQL SUM function for three fields

Question asked by stephen_forney on Nov 29, 2012
Latest reply on Nov 30, 2012 by another_martink
Can someone assist >???

What is the syntax to sum Quanity of Hours BY Month BY Charge Code ??

SELECT
@SELECT:DIM:USER_DEF:IMPLIED:WIP:w.month_begin ||', '|| w.charge_code:month_cc@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:WIP:w.month_begin:wip_month_begin@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:WIP:w.charge_code:wip_charge_code@,

@SELECT:METRIC:USER_DEF:IMPLIED:SUM(w.quantity):wip_quantity_hours:AGG@

Thanks in advance for your help.

Stephen

Outcomes