pls help..............simple conditional calculation

[#1]

Hi Experts,

i have tables linked like below.

RSM	Branch No	Branch
Mathew	79	BARKING
	134	BOREHAMWOOD
	23	COLLIERS WOOD
	74	EDMONTON
	823	ENFIELD (UA)
	115	HARROW
	24	HORNSEY
Coles	1	WEMBLEY
Adam	54	ALDERSHOT
	112	BASINGSTOKE
	195	CAMBERLEY
	47	CHERTSEY

Branch	Branch No	Working DAYS
WEMBLEY	1	8.5
MANCHESTER	2	8.5
MILTON KEYNES	18	8.5
SHEFFIELD	19	8.5
READING	20	8.5
SWINDON	21	8.5
LEICESTER	22	8.5
COLLIERS WOOD	23	8.5
HORNSEY	24	8.5
NOTTINGHAM	25	8.5
BURY ST. EDMUNDS	26	8.5
EDINBURGH	27	8.5
HAYES	28	8.5

i have to calculate the working days for RSM.

when i calculated, i m getting the result as below.

RSM Name	Working DAYS
Mathew	127.5
Coles	8.5
Adam	119

this is not the requirement.

i should get the result as

RSM Name	Working DAYS
Mathew	8.5
Coles	8.5
Adam	8.5

the result highlighted in blue is the correct one i should get.

how can i do this in the expression.

pls help................

[sunny_talwar]

Just followed you

I don't understand why both of us need to follow each other to message, but I guess that's how it works.

[#3]

i tried avg, but showing 0.85

i should get 8.5.

i tried to change number format, tried with Num(),...

but nothing works out.

help plssssss

[buzzy996]

sorry,by the time i posted my comment i was not able to see the previous discussion.

i think u have to do some data cleaning/profiling here.

[#5]

thanks for following

[sunny_talwar]

I guess is it possible to share a sample? Not easy to say what it could be without looking at it.

[#7]

not getting you.

pls be more clear

[buzzy996]

u have to share/provide here proper dataset first..i think ur copied some data from some source..some other data from different source.

due to tht,it's difficult to suggest expected solution to u.

pls share if possible ur dataset completely or some meaningful data.