1 Reply Latest reply on Jun 13, 2016 7:51 AM by khalid norat

    Parameter to return customers with change in sales <=-$48,000 and >=$48,000

    Carol Gensimore

      I found the error of my ways!  Just need to walk away for a bit.




      I have a worksheet that shows the change in revenue per customer for a six month period as both a % and $.  I want the user to input the minimum % and $ parameters. The twist is when a user inputs the minimum % and $, for example 20% and $48,000, I would like the results to include customers with <= -20% and >=20%  and

      <= -$48,000 and >= $48,000.


      The following calculation and parameters only result in positive results, not the negative.


      Please help.




      Below is the $ side of the calculation and parameter; not showing the %


      Parameter:  Enter $ Change in Six Month Sales


      Calculation for $ Change in Sales:


      if[Change in Six Month Sales $ ]>=[Enter $ Change in Six Month Sales] and

      [Change in Six Month Sales $]<= -([Enter $ Change in Six Month Sales])

      then [Change in Six Month Sales $ ] end




      Message was edited by: Carol Gensimore