Hello, I have related column here,
As you can see, I create 3 virtual column which is the Total Machine Downtime, Total Man Dowtime and Total Downtime.
I created Virtual Column which is the Total downtime to sum the two column which is the Total Machine downtime and Total Man Downtime.
SUM(SELECT(Sheeting Downtime[Downtime],([Item ID] = [_THISROW].[Item ID])))
In my 2nd Virtual Column, I want to Sum the specific column only which is the Total Man Downtime only.
and
In my 3rd Virtual Column, I want to Sum the specific column only which is the Total Machine Downtime only.
SUM(SELECT(Sheeting Downtime[Downtime], [Man Downtime]=[_THISROW].[Man Downtime]))
Thank you in advance!
Hey
Hard to test this stuff without building a copy of your app but i think it would be better to target the related column not the sheet itself. If you target the column the most of the computing is already done connecting your data, from what i can see you are just doing all that again.
You could try something as simple as this:
SUM([Related Sheeting Downtime][Downtime])
Let me know how you get on
Hello, Here is the result of the SUM([Related Sheeting Downtime][Downtime])
Hey
Add the S to downtimes i must have missed it.
Its letting you know it cant find the “Related Sheeting Downtime” Because on your table its called “Related Sheeting Downtimes”
Updated formula
sum([Related Sheeting Downtimes][Downtime])
1 Like
Hello,
Here is the result, The sum was same on the total downtime, I want to Sum the specific column like on the picture, the highlighted rectangle color Yellow was the Man Downtime and when you add the downtime from that column, i want the result was 00:40. And the green rectangle is 00:34.
Thank you for your response sir!
Ah this makes a lot more sense, sorry i didn’t understand before. The 2 formulas are below but they do assume the blank cell define the cell not being the one to be counted.
man downtime:
SUM(SELECT([Related Sheeting Downtime][Downtime], ISBLANK([Machine Downtime])))
Machine Downtime
SUM(SELECT([Related Sheeting Downtime][Downtime], ISBLANK([Man Downtime])))
it may be worth adding another column to your sheeting downtime that defines what kind of downtime it is and use your current columns as the notes for reference. This would make the forumla a bit nicer
2 Likes
Hello sir, here is the result! Great! Thank you sir! God Bless!
Hello sir, i change the code from SUM(SELECT([Related Sheeting Downtime][Downtime], ISBLANK([Machine Downtime]))) to SUM(SELECT([Related Sheeting Downtime][Downtime], ISNOTBLANK([Machine Downtime])))…I change the ISBLANK to ISNOTBLANK. BTW Sir Example if the Man downtime has no entry, how do i hide the Virtual column from Total Man Downtime.
Hey,
head to the data section and click the pen next to your virtual column, then on the show option select the forumla icon and input similar formula
Isblank([Machine Downtime])
1 Like
Cool! Thank you again sir! Sorry I’m newbie. I start learning from this group, sometimes i do the trial and error, then when i give up. I start ask a question here in the forum. Thank you again sir!
Hey thats how we all learn so don’t worry.
2 Likes
Sir When i put this code Isblank([Man Downtime])
The Virtual Column was hide, That’s correct, Then when i put entry on the Man Downtime it’s still hide. The Virtual column not showing up.
hey
sorry i forgot about the related sheet…
ISBLANK([Related Sheeting Downtime][Machine Downtime])
1 Like
Nothing change sir, It’s same, Not showing up when i put entry on the downtime.
Your code was correct, if the man downtime or machine down time has no entry, the virtual column was automatically hide. But when i put entry on the man downtime or machine downtime, it’s still hiding.
Look at this, i put the code ISBLANK([Related Sheeting Downtimes][Man Downtime]) on the Virtual column of Total Man Downtime then still hiding on the app.
