Hi @AndreaHB ,
Can you please remember to post your code in Text as it saves re-typing here. This code is OCR'd, so please watch spelling. I broke this down a bit to save duplicity
With(
{
_Assets:
Filter(
gal_Assets.AllItems,
chk_SelectAsset.Value
),
_Attach:
LookUp(
’DEV - BC Attachments’,
BCID = var_currBC.ID,
AttachmentType.Value = "Financial model”
)
},
If(
IsEmpty(_Assets) ||IsBlank(_Assets) ||
First(_Assets).currPhase = 0 ||
First(_Assets).currPhase = 20 && IsBlank(_Attach) ||
Countlf(
Ungroup(
Filter(
col_tempAssets,
mandatoryPhase = First(_Assets).currPhase
),
"assetvalues"
),
requirementMet <> true &&
assetID in _Assets.ID
) > 0,
DisplayMode.Disabled,
DisplayMode.Edit
)
but the bit I do not understand the logic on is here - what are you doing with the ungrouped table and what are you filtering the bottom values against ?
Countlf(
Ungroup(
Filter(
col_tempAssets,
mandatoryPhase =
First(
Filter(
gol_Assets.Allltems,
chk_SelectAsset.Value
)
).currPhase
),
"assetvalues"
),
requirementMet <> true &&
assetID in Filter(
gal_Assets.AllItems,
chk_SelectAsset.Value
).ID
) > 0
