Hello . I need help with a formula.
In the Reading form
as soon as I choose the Machine
he bring me to
Previous Entry and most recent Previous Exit.
Otherwise , it will bring the Current Input and Current Output values .
@Steve can you help me ?
If I understand you correctly you can try
INDEX(
SELECT(
Lucky Machine[target column here],
[key column of Lucky Machine]
=
MAXROW(
"Lucky Machine",
"_ROWNUMBER",
[IDMaquina_Eliura] = [_THISROW].[IDMaquina_Eliura]
)
),
1
)
in the Initial Value of each of the columns (adopt the [target column here] to each column)
hi , i used this expression ... thanks for your help!😀
if(
isblank(
any(
SELECT(Leitura[EntradaAtual],[IDleitura]=
MAXROW("Leitura","EntradaAtual",[IDmaquinaLeitura]=[_THISROW].[IDmaquinaLeitura])))),
[IDmaquinaLeitura].[EntradaAtual],
any(
SELECT(Leitura[EntradaAtual],[IDleitura]=
MAXROW("Leitura","EntradaAtual",[IDmaquinaLeitura]=[_THISROW]. [IDmaquinaLeitura]))))
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |