14 Replies Latest reply on Jul 27, 2018 10:01 AM by tarang.patel.3

    LOD with two data sources

    tarang.patel.3

      Hi!

       

      I am trying to create a LOD where part of my data comes from another source.

       

      This is what my data looks like, but when I drop the "product" from rows I do not get values. Normally I would solve this by using LOD, but the "Orange" product comes from another source.

       

       

                                            

       

      if attr([Product]) = 'red' then sum([Per/Unit]*[Units])

       

       

      elseif attr([Product]) = 'green' then sum([Per/Unit]*[Units])

       

       

      elseif attr([Product]) = 'blue' then sum([Per/Unit]*[Units])

       

       

      elseif attr([Product]) = 'orange' then [Orange Cost ]      <------------------------ this value is from the secondary source

       

       

      else

      null

      end

       

       

       

      What's the best way to handle this?