Why doesn't the formula work?

[Nora104]

As the below, the formula doesn't work:

sum({<Store_Name={"=sum({<WeekName={"2020/52"}>}SO_RealAmt)>0 and sum({<WeekName{"2019/52"}>}SO_RealAmt)>0"}>}SO_RealAmt)

Is there anyone know how to modify？

[Almen]

What are you trying to achieve here? It looks like 

sum({<Store_Name={"=sum({<WeekName={"2020/52"}>}SO_RealAmt)>0

is part of a condition but 

and sum({<WeekName{"2019/52"}>}SO_RealAmt)>0"}>}SO_RealAmt)

has no condition attached to it. 

[Nora104]

the blue is the condition:

Store_Name satisfy both two conditions:

1.sum({<WeekName={"2020/52"}>}SO_RealAmt)>0

2.sum({<WeekName={"2019/52"}>}SO_RealAmt)>0

[tresesco]

Change the quotes (to single) for inner modifiers like:

sum({<Store_Name={"=sum({<WeekName={'2020/52'}>}SO_RealAmt)>0 and sum({<WeekName{'2019/52'}>}SO_RealAmt)>0"}>}SO_RealAmt)

[Nora104]

Thank you!It works!

But another problem is ：

Another condition is that [Store_Name] is required to be the same [Store_Region] in 2020/52 and 2019/52.

Store_Name and Store_Region are both field names.

It seems difficult to limit in the formula.

What do you think？

[tresesco]

Let's close this one by giving like/marking correct answer, and then move to another problem. For another problem, try to create a sample app/data and explain your expected output in that context - in a new post may be.