3 Replies Latest reply: Apr 26, 2017 8:09 AM by Coffi AZIAKOU

# Can someone help me ???

 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 ?

• ###### Re: Can someone help me ???

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?

• ###### Re: Can someone help me ???

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]

)

• ###### Re: Can someone help me ???

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.