2 Replies Latest reply on Sep 6, 2018 7:41 AM by Daniil Saiko

    Calculate fixed output

    Daniil Saiko

      Hi,

       

      I am blending two sources of data that both can have incomplete data into one corrected set. Running into a problem when trying to do basic calculations with this data.

       

      Data looks something like the following, where I can have both data points (annual or transactional) or either of them. And then have to deconflict which data to use

           

      ProductClient IDTransaction IDAnnual VolTransaction Vol
      XA2310050
      XA3410020
      XA5610030
      XB78null10
      XB89null20
      XB90null30
      YC1350null
      YC2450null
      YC3550null

       

        

      As the first step I am able to display

        

      Client IDRevised Vol
      A100
      B60
      C50

       

      ATTR([Revised Vol]) is the pill, ATTR is used to prevent any further aggregation as it combines aggregated and non aggregated data

       

      But further aggregation breaks as it tries to sum by transaction volume in some cases due to data ex:

      {FIXED [Product] : SUM([Revised Vol])}

       

      Any suggestions to introduce higher level aggregation? The easiest way I see is to somehow used fixed output, just cannot get it to work