Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a straight table with following structure. the final column $(vAHTRankDivision) is a formula defined as variable during data load. I want is one more column where the this value repeats for all values in first column.
i.e 53.42% should be repeated for all ID 83 in column 1, 99.07% should be repeated for all values 345 in column 1, '-' for 384. This is basically value of $(vAHTRankDivision) for the lowest value of date in column AsOfWeek.
@sunny_talwar , @swuehl - again many post where i saw your reply on similar posts, but majority of them are in qvw and i can't open them anymore on my system. qvf file is attached here.
You can try this, but there might be an easy way to do this
FirstSortedValue(TOTAL <[Person(Person - who) : Employee_Number]> Aggr($(vAHTRankDivision), [Person(Person - who) : Employee_Number], AsofWeek), Aggr(AsofWeek, [Person(Person - who) : Employee_Number], AsofWeek))
You can try this, but there might be an easy way to do this
FirstSortedValue(TOTAL <[Person(Person - who) : Employee_Number]> Aggr($(vAHTRankDivision), [Person(Person - who) : Employee_Number], AsofWeek), Aggr(AsofWeek, [Person(Person - who) : Employee_Number], AsofWeek))