3 Replies Latest reply on Jun 18, 2018 5:03 AM by Simon Runc

    Dateiff with multiple criteria?

    Antonio Santos

      Hello there,

       

      The challenge here consists of displaying how many days left of inventory we have on the orange bar chart.

       

      I imagine it would follow these steps:

       

      • Calculate sales for the last 90 days if Product Code is X;
      • Divide current inventory by the result the aboe calculation.

       

      I would like to know if this is possible having one Calculated Field only.

       

      Thank you!