Forum Discussion
Tables - incomplete months - calculation issues
Hello,
Tried copilot but cant quite get it right unfortunately.
So Ive got the 'dummy rows' in place. Thought they were working fine however my removing duplicates does not get rid of them all. So in summary.
For each resource they have multiple rows. Some have two or more rows for one month. Most have one. On top of this I have a dummy month row for each resource now in place in my merged queries. That is all working fine.
I just need to do the following.
If any of the dummy rows already have a 'real' row in place for the same month - I want to remove them. If any do not have a real row in place for the same month - I want to keep them. FTE column shows the hours I am interested in. All the real rows have an actual number in them. For all the dummy rows I have entered 0 for these.
Columns in question i need to use:
User:
MergedMonthNames:
FTE:
Table example below of what I have now and what I want to to result in. For the table there will be multiple resources that this should work for. Any help would be amazing !! Dummy rows are in red.
| User | MergedMonthNames | FTE |
| David | January | 0.5 |
| David | January | 0.5 |
| David | February | 1 |
| David | March | 1 |
| David | April | 1 |
| David | January | 0 |
| David | February | 0 |
| David | March | 0 |
| David | April | 0 |
| David | May | 0 |
| David | June | 0 |
| David | July | 0 |
| David | August | 0 |
| David | September | 0 |
| David | October | 0 |
| David | November | 0 |
| David | December | 0 |
| User | MergedMonthNames | FTE |
| David | January | 0.5 |
| David | January | 0.5 |
| David | February | 1 |
| David | March | 1 |
| David | April | 1 |
| David | May | 0 |
| David | June | 0 |
| David | July | 0 |
| David | August | 0 |
| David | September | 0 |
| David | October | 0 |
| David | November | 0 |
| David | December | 0 |
- RobinIrving1 year agoFrequent Visitor
Anonymous danextian
Hello both. Sorry I should have tagged you in this. Apologies Im new to here !! You have ben very helpful to date. I just need to work out the above and then will finally be sorted !!
Much appreciated.
Robin