help in a calculated expression with mix of AGGR, MAX and SUM
Hi to all,
really complex for me, SOS SOS !!!
PLEASE HELP TO FIND THE RIGHT EXPRESSION FOR "DIVISION" with this rule:
- Focus only on the sum of AMOUNT where TYPE_GRADE is the MAX value.
-if sum of amount only on max value for type_grade (by mydate and sitenumber) is egal to 0, we keep the lower value of type_grade, if different of 0, then division of all couple of mydate/site number is this max value of type_grade