Calculationg fill rate

[Anonymous]

Hi, I'm trying to calculate TAT 90% fill rate (among other expressions) I have a huge table loaded. The way to calculate it is...

1) Sort TAT by month (I have no way to sort it in load script due to table structure so it has to be done internally with an aggr exp or something)

2) Count number of rows per month

3) Calculate 90% out of step 2

4) Take TAT vaue for row calculated in step 3

[Anonymous]

Helps a lot! I wasn't getting what concat was doing, very usefull, thank you very much!