8 Replies Latest reply: Jun 19, 2018 2:05 AM by Daniel Sørensen RSS

    using nested-if´s without excluding values

    Daniel Sørensen

      HI

       

      I not sure how to research my way to an answer to this question, as I do not know where to start

       

      I am using Nested if´s (I think that it is what it is called) to make certain categories to be used for analyzing data, and showing the categories totals in charts.

       

      Problem with this solution is that if i choose the first if to look for something all my data includes, then the rest of the if´s will not find anything else.

       

      So how to use something like nested if´s without excluding data when the first if excludes all data?

       

      Example.

       

      cost_receivedpropertyready_for_billing

      30-04-18

      73486645N
      73565511Y
      31-05-1873798564Y
      73744564N

       

      Category:
      Load
      
      Date,
      property,
      ready_for_billing
      
      
      If(Date>0 AND ready_for_billing='Y' OR ready_for_billing='N'
      ,' Ready to be proccesed'
      ,
      if(ready_for_billing='Y'
      ,' Ready for billing' )) as status
      
      

       

      If i use this data load, the 'Ready to be processed' will filter out the 2 lines with date and Y or N

      So when the second if is done, the one with the date in cost_recieved, will not be included..

       

      'Ready to be processed' = 2 lines

      'Ready for billing' = 1 line. (But I want it to disregard the first if, and get 2 lines)

       

      So how do a make the same categories above, were every if goes through the total, and not only the one that the first if removed?