1 Reply Latest reply on Feb 20, 2018 4:39 PM by Nicole Le Prohn

    Use an aggregate from a separate data source as a fixed number in calculation

    Jason Woodward

      I'm trying to figure out a way to use an aggregate, from a separate data source, in a calculation in my primary data source.  I hope this makes sense.  I don't want to link the sources, and there is no real way to do so.  I'm just trying to use the info from the other data source as a multiplier that gets updated with the data source.  EX:

      Source 1:

      Itemamount

      a

      10

      b12
      c8
      d13

      Aggregate = Sum(amount)

       

      Source 2:

       

      itemCostAdjusted Cost=Cost*Sum(amount)
      a5
      b4
      c6