topic Re: calculations with columns , but issue with null entries in App Development

calculations with columns , but issue with null entries

joeybird — Thu, 09 Apr 2015 14:55:50 GMT

I have two columns in a database

Column one = Teaching_Session_Tutor (This person is scheduled to teach the session)

Column two = Teaching_Session_Tutor_Actual (This person actually teaches the session)

the issue I have I want to count the sessions taught actual by tutor name, by month ect

but problem I have is

Teaching_Session_Tutor column is filled in (no problems there)

but because they taught the session too ....some people have forgotten to enter the name in Teaching_Session_Tutor_Actual and it shows null

is there a way of way of counting between these two columns, and finding the actual correct number of sessions taught by a tutor?

Kind Regards

Joeybird

jpenuliar — Thu, 09 Apr 2015 15:07:42 GMT

if(isnull ([Column two]),[Column one],[Column two]) as [Colum Three]

jpenuliar — Thu, 09 Apr 2015 15:08:51 GMT

you can use [Column three] to count the sessions based on actual tutor

joeybird — Mon, 13 Apr 2015 10:27:05 GMT

worked!!!

this work really well for a number of scenarios

thank you xx

Kind Regards

Joeybird