6 Replies Latest reply: Mar 23, 2017 11:10 AM by Carlos Monroy RSS

    If then statement problem.

    Ariana Ford

      I created this expression for a calculated dimension:  If(ProgressStatus = 'PastDue', 'Past Due', 'On Time')

       

      I am using it to split the data. Some of the projects fall in both categories apparently so they are being dulicated. Can you help me make them so that they are not duplicated. If they are duplicated they should be Past Due, as anything that contains Past Due should be past due and not on time at the same time. I have attatched my data, and the 3 items being duplicated have been highlighted in yellow.

       

      Thanks in advance!