Good morning friends!
I am making a report grades of the students so that it can be sent by e-mail with a click, and I use the “ClickToSendEmail” app to learn how to do it (I am a beginner).
<<Start: FILTER(Reports all students,true)>>
Name-Surname: <<[Name-Surname]>>
N°ID: <<[N°ID]>>
Grade-level: <<[Grade-Level]>>
Phone-Number: <<[Phone-Number]>>
E-mail: <<[E-mail>>
<>
2)PROBLEM: I have problems creating a formula to generate a report with the best 10 students, that is, the students with the best grades. I built the following formula but it doesn’t work:
<<Start: IF(FILTER(Report of the 10 best students,true),TOP(SORT(“Class-1”[Grade-Level], 10)))>>
Name-Surname: <<[Name-Surname]>>
N°ID: <<[N°ID]>>
Grade-level: <<[Grade-Level]>>
Phone-Number: <<[Phone-Number]>>
E-mail: <<[E-mail>>
<
How can I fix the problem?
Thanks!
Julio
P.S: I hope you can understand the question as I use a translator.
Solved! Go to Solution.
Move the <<Start>>
tag inside the first cell of the data row, and the <<End>>
tag inside the last cell of the first row.
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |