Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear sir / madam
Can someone help me to resolve the issue on Grade which is missing in table 2 attached ?.
Thank you
Tracy
Try this:
Aggr(If(Sum(Score) >= [Lower Score] and Sum(Score) <= [Upper Score], Grade), Code, Grade)
Try this:
Aggr(If(Sum(Score) >= [Lower Score] and Sum(Score) <= [Upper Score], Grade), Code, Grade)
A script solution in the attachment