2 Replies Latest reply: Apr 13, 2015 1:36 AM by bhargav maddina RSS

    Can any one explain below syntax with the following table?

      Variable:

      vdeptid=Concat(DISTINCT deptid,',')

       

      Expresion in Bar chart:

      =Avg({1<deptid={$(vdeptid)}>}sal)

       

      Requirements:

      1.Sum of salary of selected employee.

      2.Avg salary of department, in which selected employee is working

      3.Avg salary of all department.

       

      EidEnameDeptidSal
      101Bhargav101000
      102Vishnu102000
      103Vijay203000
      104Subbu304000
      105Sandeep405000
      106Sravani406000