What is the correct way to make a condition in the wnidow Format rules for the column [PRICE].
The required condition is as follows:
Searching for equal values in the column [SIZE] & it should be lowest value in the column [PRICE].
The value that satisfy both conditions should be marked in red in the [PRICE] column.
Attached are picture for explain.
Data/Columns
UX/Format Rules
In the date entry page
Solved! Go to Solution.
Try this expression:
[Price] = MIN(SELECT(Market Surve[Price], [Size] = [_THISROW].[Size]))
Try this expression:
[Price] = MIN(SELECT(Market Surve[Price], [Size] = [_THISROW].[Size]))
@WillowMobileSystems I followed your instructions and are now working fine.
Iโve used the expression suggested by you in the window Format rules
[Price] = MIN(SELECT(Market Surve[Price], [Size] = [_THISROW].[Size]))
lowest value in the column [PRICE] it show red
Thank you very much
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |