9 Replies Latest reply: Apr 16, 2014 10:27 AM by Alan Farrell RSS

    set analisys

    Andrea Masciulli

      Hello to all

      I need via set analisys to calculate the sum of a field only for values of the field where the date approval is valued.

      I use the syntax is sum ({$ <dtaApprovazione = {2014}>}

      the syntax is correct but I do not return anything because the field because the field is given in the format dd / mm / yyyy, but by year (dtaApprovazione) = {2014}, it gives me a syntax error.

      actually what I should do is to exclude data where the DtaApprovazione is nothing but it seems to me that's set-analisys only works with the equal comparison operator (=) and not different (<>).

      Thanks for your cooperation

      Andrea