Hi,
I created a virtual column to sum the time (Total tiempo asignado) from related table
The formula in virtual column (Total tiempo asignado) is (SUM(SELECT(SEGUIMIENTO[TIEMPO ASIGNADO],[RUT]=[_THISROW].[RUT])))
But I need to filter the sum only if [ESTATUS] =‘No disponible’. [ESTATUS] is a virtual column from Seguimiento Table (Type: YES/NO)
I tried to filter in ‘valid if’ using IN(‘No’,Seguimiento[estatus]) but it did not work
desired result is 100% not 200% in [Total tiempo asignado]
any idea?
Solved! Go to Solution.
Yes, sorry, I forgot momentarily that it was a Virtual Column. I just wanted to confirm how the values were being written for that column.
I am not seeing anything wrong with expression based on what I know from you.
Since it is a Yes/No column, any combination of “Yes/No”, “Y/N”, true/false or TRUE/FALSE should work as a value to compare against.
I would try changing the value of “No” to FALSE to see if that makes a difference.
How is “Tiempo Asignado” claculated?
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |