Please, help me to resolve this problem.
I have few string and 1 Number fields on my Report
Groupped by Code.
Code ID1 ID2 OrderNo Cost(Number)
I need to have
Count of ID1 per Code
Count of ID2 per Code
which I just inserted Count and it works.
Now I need Count{ID1}*Cost
then result of this to divide by ID1.
What is the best way to go when you need to work with Counts and then manipulate it?
Thanks
I have few string and 1 Number fields on my Report
Groupped by Code.
Code ID1 ID2 OrderNo Cost(Number)
I need to have
Count of ID1 per Code
Count of ID2 per Code
which I just inserted Count and it works.
Now I need Count{ID1}*Cost
then result of this to divide by ID1.
What is the best way to go when you need to work with Counts and then manipulate it?
Thanks