6 Replies Latest reply: Sep 12, 2013 6:00 PM by Manuel Capella Monsonís RSS

    SET ANALYSIS RANGE SUM

      Good afternoon.

      I need your help.

      I want to calculate an amount (sum), but only for customers in a certain range (between two variables, that can be modified by the user). The user selects defines the range with vMinRev and vMaxRev. Only those customers in range should appear. The amount (sum) for a customer must be between vMinRev and vMaxRev.

      I tried with aggr, and with set analysis:

      This is my set analysis function:

      Sum({$<Concept0={'REV'},Cod_Cust=P({$<Sum({<Concept0={'REV'} Amount={">=$(=vMinRev)<=$(=vMaxRev)"}>}Cod_Cust)>}Amount).

       

      Thanks.