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?
Virtual Columns can be included in expressions like any other column. Update your SELECT expression with an AND() and your Virtual Column column like so:
(SUM(SELECT(SEGUIMIENTO[TIEMPO ASIGNADO],AND([ESTATUS]="No",[RUT]=[_THISROW].[RUT]))))
Hi, Thanks
I updated the expression but it not made the sum
(SUM(SELECT(SEGUIMIENTO[TIEMPO ASIGNADO],AND([ESTATUS]=โNoโ,[RUT]=[_THISROW].[RUT]))))
Can you show the row data (i.e. spreadsheet) from the Seguimiento table?
Yes, has 22 columns
[ESTATUS] is a virtual column where app formula is
([FIN] < TODAY())
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?
Thanks John!
it is working with FALSE
(SUM(SELECT(SEGUIMIENTO[TIEMPO ASIGNADO],AND([ESTATUS]=FALSE,[RUT]=[_THISROW].[RUT]))))
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |