Forum Discussion
Solved
Calculated Column If with filter
Hi experts!
I have a table that shows me for all orders mutiple rows with different values:
| Order | State | Key | Value |
| 100 | A | A1 | 50 |
| 100 | B | A1 | 60 |
| 101 | A | A1 | 40 |
Here I would like to add a calculated column that returns for each order (there are mutpliple rows per order) true the order has any entry with
- State = 'A'
- Key = 'A1'
How is that possibleas a calculated column?
joshua1990 . Not very clear
New column =
var _cnt = countx(filter(Table, [Order] =earlier([Order]) && [State] = "A" && [Key] ="A1") , [Order])
return
if(isblank(_cnt), false() , True() )
1 Reply
joshua1990 . Not very clear
New column =
var _cnt = countx(filter(Table, [Order] =earlier([Order]) && [State] = "A" && [Key] ="A1") , [Order])
return
if(isblank(_cnt), false() , True() )