Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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] |
)
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?
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] |
)
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.