Forum Discussion
Sum total per categroy
I am trying to have the total Labor hours which is a measured column within the table public_work_order_logs per each class which is in its own table public_classes. But as you can see it is giv...
I found the issue it had to do with the relationships between my tables
Greg_Deckler
Community Champion
Community ChampionAnonymous Well, something is either a measure or a calculated column. Looks like your Labor Hours is a calculated column. If I am reading your data model correctly the issue seems to be that your Class column (Name in public classes table?) is not related to your public works order log table and thus your Labor Hours calculation. You will need relationships defined with the directions of those relationships such that the first table filters the other. Also, it is almost certain that if Labor Hours is a calculated column you will need this to be a measure instead.