7 Replies Latest reply on Jul 18, 2018 8:45 AM by Jim Dehner

    Calculation based on boolean status

    Kevin Ward

      Hi,

      New user here. I want to make a chart based on sample status and whether it has been returned or not.

      The issue i have is that I have multiple entries per sample, some have Returned=True, some=False - for the same sample. The rule is that if any entries for that sample have Returned=True, then the Returned value for the sample is True.

      When i make a chart on the below data, it indicates there are 5 samples in total where i have only 4 in reality. I need a calculation that sees whether there are any "true" values in the Returned column based on the sample id and outputs appropriately and use this column instead. could you please help with the calculation?

      Thanks