1 2 Previous Next 26 Replies Latest reply on May 9, 2017 8:56 AM by Okechukwu Ossai

    Calculations not working properly -- LOD possibility

    Dan Hunnewell

      Hello,

       

      I am attaching a set of data exported from Tableau which includes 2 calculated columns. I have also listed the calculations for these fields in columns H and I.

       

      I am trying to create 2 calculations that do the following:

       

      1. When a product ID has "1P sales" > 0 (Column B) and also has "3P/PVL Sales" (Column E)... List that amount within "3P Sales on 1P items" (Column C)

      2. When a product ID has "1P sales" <= 0 (Column B) and also has "3P/PVL Sales" (Column E)... List that amount within "3P Sales on 1P items $0" (Column D)

       

      The formula seems to work for some of the items but not all. The goal would not be to display it as a table but within a bar chart for each column.

       

      Please let me know if this is a candidate for an LOD expression which I have tried with no success.

       

      Best,

      D

        1 2 Previous Next