Nicesoni_ash
New member
- Local time
- Today, 22:19
- Joined
- Sep 17, 2013
- Messages
- 9
Hi,
I have a query that returns me value in this format.
# M1Rank GV-Q M1Rank GV-Q
1 CONS 99 CONS 2895
5 CONS 15 CONS 15
Now I want to make it show one more column in the end calculates what's the RANK and based on that rank, it gives that customer 0 or 1. I want to calculate total points he earn by summing up all those points he got based on his Rank in each month.
I can check what rank he has and on based on that I can give him 0 or 1 in VB through if and else condition and I made a function for that too that resulted in a 0 or 1 in the last field, but how can I use that function to calculate both months Rank values?
e.g if he has 1+1in total for two months, I want to show in final column the total of this, that is 2. Is this possible through any function or such.
I have a query that returns me value in this format.
# M1Rank GV-Q M1Rank GV-Q
1 CONS 99 CONS 2895
5 CONS 15 CONS 15
Now I want to make it show one more column in the end calculates what's the RANK and based on that rank, it gives that customer 0 or 1. I want to calculate total points he earn by summing up all those points he got based on his Rank in each month.
I can check what rank he has and on based on that I can give him 0 or 1 in VB through if and else condition and I made a function for that too that resulted in a 0 or 1 in the last field, but how can I use that function to calculate both months Rank values?
e.g if he has 1+1in total for two months, I want to show in final column the total of this, that is 2. Is this possible through any function or such.
