The user select the item, unit and size. I wanna pull the price,code and factor for each combination of selection(item,unit, size).
please have a look here:
I tried to create an expression just for price. it is not valid. can you guys help me out??
SELECT(Prod[Price], ([Size] = [_THISROW].[Size]), ([Unit] = [_THISROW].[Unit]), ([Item] = [_THISROW].[Item]))
You made a good job so far.
Just missing a AND() statement
SELECT(Prod[Price],
AND(
[Size] = [_THISROW].[Size],
[Unit] = [_THISROW].[Unit],
[Item] = [_THISROW].[Item]
)
)
Thank you Its working, but it is not auto selecting. I entered it in valid_if
Valid_IF needs to be a TRUE OR FALSE result, not a number
Got it to work in initial value!! with Any()
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |