1 Reply Latest reply: Feb 10, 2014 8:30 AM by Srikanth P RSS

    Null value afer box selection

      hi all,

      i have a graph like this :

       

      DateN°Employee%Partecipation
      201112311045%
      201212311254%
      201312311365%

       

      %Partecipation is calculated by expression that include the "DATE" information, "employee" is calculated with count expression

      I have 3 different selection boxes for DAY - MONTH - YEAR, if i select i.e. 2013 12 31 i want see all rows values for MONTH=12 and DAY = 31

      It works for N*employees count(COUNT({$<YEAR=>}EmpID),but for %Partecipation i have null value in 2012 and 2011 rows, maybe because in %Partecipation formula i need Date -(Count({$<YEAR=>}MATRICOLA)

      How can i resolve it?

       

      Tyvm

       

      Simone