Can someone help me ???

[#1]

Avg({$<	[Type Facture]={'Avoir'},
	([Fact. Mt MO]
	+ [Fact. Mt D]
	+ [Fact. Mt RF]
	+ [Fact. Mt FV]
	+ [Fact. Mt FA]
	+ [Fact. Mt FD]
	+ [Fact. Mt A]
	) = {">=$(=vMt_FT_Min) <=$(=vMt_FT_Max) >=$(=vMt_FT_Max_1) <=$(=vMt_FT_Min_1)"}

    >}

	[Fact. Mt MO]
	+ [Fact. Mt D]
	+ [Fact. Mt RF]
	+ [Fact. Mt FV]
	+ [Fact. Mt FA]
	+ [Fact. Mt FD]
	+ [Fact. Mt A]

)

This instruction is not working. Can someone urgently help me ?

[sunny_talwar]

This instruction is not working. Can someone urgently help me ?

When you say not working, what is the issue? Error? Incorrect result? Something else? Can you share what it should do and what it is doing for you?

[vinieme12 · Accepted solution]

You cannot have evaluations on the Left side of the Equal sign, you probably need to create a new field that totals all of these fields which you can refer in set analysis

Avg({$<	[Type Facture]={'Avoir'},
	([Fact. Mt MO]
	+ [Fact. Mt D]
	+ [Fact. Mt RF]
	+ [Fact. Mt FV]
	+ [Fact. Mt FA]
	+ [Fact. Mt FD]
	+ [Fact. Mt A]
	) = {">=$(=vMt_FT_Min) <=$(=vMt_FT_Max) >=$(=vMt_FT_Max_1) <=$(=vMt_FT_Min_1)"}

    >}

	[Fact. Mt MO]
	+ [Fact. Mt D]
	+ [Fact. Mt RF]
	+ [Fact. Mt FV]
	+ [Fact. Mt FA]
	+ [Fact. Mt FD]
	+ [Fact. Mt A]

)

[#4]

you're right. I tried to create a new field named "Fact. Mt Total" which is the sum of the others and that worked.

Thank you.