Solved: Counting wrong - Page 2

punkshift · 09-10-2021 03:33 AM

I have Assets Table and Asset Checkin Checkout Table. I’m trying to count how many times an asset has been checked out.

In the Assets Table, I have a virtual column that counts the Check Out Date of a specific Asset Tag # with this Expression:

COUNT(SELECT(Asset Checkin Checkout[Checked Out to], [Asset Tag #]=[_THISROW].[Asset Tag #]))

However, if I try to check in the asset, it still counts it as one but I didn’t put anything in that column but instead in the Check In Date.

Same goes with the Scanners and Scanner Checkin Checkout Table but both Checkouts and Checkins Virtual Columns count the same thing.

COUNT(SELECT(Scanner Checkin Checkout[Check Out Date], [Asset Tag #]=[_THISROW].[Asset Tag #]))

COUNT(SELECT(Scanner Checkin Checkout[Check In Date], [Asset Tag #]=[_THISROW].[Asset Tag #]))

punkshift

I tried your suggested expression, however, it didn’t work for me or I just didn’t do it right. lol

Anyway, upon looking at the links you provided this is what I came up with:

COUNT(FILTER(“Asset Checkin Checkout”, AND(ISNOTBLANK([Check Out Date]), ([Asset Tag #] = [_THISROW].[Asset Tag #]))))

And it works now.

Thanks!