Distinct Count of Blank Lines
Hey Everyone, i am essentially needing a distinct count of all the lines below (displayed in the left) to be reflected in the card to the right. I need a calculation to look at a distinct count of all items which have a blank in order quantity (disregard the placeholder coulumn). I essentially need the Count of Desc column of 140 to be reflected in the card to the right. My table names are Articles (i am using Desc in this table), Purchase History ( I am using Order Quantity in this table)
