Result formula is changing to 0 when I save

[OlivierCmar]

Hello,

I get an issue which is very annoying for me, the result of my formula is ok but when i save, the result is switching to 0. Why ? Please help me.

and after saving 

[Steve]

Please post screenshots of the expressions involved.

[OlivierCmar]

if([Sous-thème question] = "1. Les premiers pas",
if(AND(COUNT(SELECT(Reponses[Points], AND([Sous-thème question] = "1. Les premiers pas",[Thème question] = [_THISROW].[Thème question], [ID ECODEFIS]=[_THISROW].[ID ECODEFIS], AND([Concerné par le défi ?] = "TRUE", OR([Défi relevé ?] = "TRUE", [Nous avons validé ce défi] = "TRUE")))))>1,
COUNT(SELECT(Reponses[Points], AND([Sous-thème question] = "1. Les premiers pas",[Thème question] = [_THISROW].[Thème question], [ID ECODEFIS]=[_THISROW].[ID ECODEFIS], AND([Concerné par le défi ?] = "TRUE", [Défi relevé ?] = "FALSE", [Nous avons validé ce défi] = "FALSE"))))=0),[Points],0),
if(AND([Concerné par le défi ?] = "TRUE", OR([Défi relevé ?] = "TRUE", [Nous avons validé ce défi] = "TRUE")),[Points],0))

[Steve]

I don't see anything wrong with your expression. Please post a screenshot of the configuration of the column that uses this expression.

[OlivierCmar]

I tried to change virtual column name and formula but nothing change but same behaviour !

[OlivierCmar]

With this script the result stay OK after saving

IF(
[ID QUESTION].[Sous-thème] = "1. Les premiers pas",
COUNT(
SELECT(
Reponses[Point si concerné],
AND( [Sous-thème question] = "1. Les premiers pas",
[Thème question] = [_THISROW].[Thème question],
[_THISROW].[ID ECODEFIS]= [ID ECODEFIS]
)
)
),
99
)

but with this one no 

IF(
[ID QUESTION].[Sous-thème] = "1. Les premiers pas",
COUNT(
SELECT(
Reponses[Point si concerné],
AND( [Sous-thème question] = "1. Les premiers pas",
[Thème question] = [_THISROW].[Thème question],
[_THISROW].[ID ECODEFIS]= [ID ECODEFIS],
[Concerné par le défi ?] = "TRUE"
)
)
),
99
)

and the only difference is [Concerné par le défi ?] = "TRUE"

For me it's a bug because when I save the "Expression Assistant" sheet the result is correct but after saving, the result is 0. How the app can have two result for the same formula ???

[OlivierCmar]

For me it's a bug because when I save the "Expression Assistant" sheet the result is correct but after saving (*THE APP) , the result is 0. How the app can have two result for the same formula ???

[Steve]

---

@OlivierCmar wrote:

the only difference is [Concerné par le défi ?] = "TRUE"

---

Your test is comparing a Yes/No value ([Concerné par le défi ?]) to a Text value ("TRUE"), which is (apparently) handled differently depending on where it's evaluated. Use just [Concerné par le défi ?] like this:

AND( [Sous-thème question] = "1. Les premiers pas",
  [Thème question] = [_THISROW].[Thème question],
  [_THISROW].[ID ECODEFIS]= [ID ECODEFIS],
  [Concerné par le défi ?]
)