Hi there!
Hope someone can help me as I have been struggling with this for days.
I am trying to create an app that will calculate the volume of a package.
There are 5 different packages i.e. A, B, C, D and E.
The user will see a dropdown (ENUM) and select the Package.
The user can only choose one type of Package.
When the package is selected, the corresponding Volume is captured.
For A, B and C, the Volume is known and is fixed. See the above table.
However, if the user selects either D or E, an input field should appear, where the user can enter any value. This user defined value is then captured instead.
Thank you.
Initial Value expression for Volume:
IFS(
IN(
{"A" , "B" , "C"},
Tablename[Package]
),
LOOKUP(
[_THISROW].[Package],
"TableName",
"Package",
"Volume"
)
)
Thank you so much Levent. I will try it out.
Youโre welcome
I am trying to construct a Valid If() Statement to filter out previously selected values by the user.
SELECT(Board [Board], true) -SELECT(Board Registration[Board],CONTAINS(Gifter[Gifter], [_THISROW].[Gifter]), true)
This works but it filters out the values selected by any user.
Please can you assist me with the formula.
SELECT(Board [Board], true) - SELECT(Board Registration[Board],( [Gifter] = [_ThisRow].[Gifter]), true)
Figured it out!!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |