Recent content by dv8123456789

wow, this well beyond me!! Thanks, hopefully I can get this to work. I have made a couple of changes I think I need to make (changed person and mnth to strings from variant as they are texts - think that's what you meant and also changed the code from person to person reference because that is...

Didn't realise you could attach, sorry

Sorry that table didn't come out right. lets see if this works... Person Ref Data Type Measure Project Ref Month Data Value A N Other Capacity Days Oct 22 A N Other Capacity Days...

The table name it comes from is called Demand and capacity which contains a number of columns but the key ones here are as follows Person ReferenceData TypeMeasureProject ReferenceMonthDataValueA N OtherCapacityDays Oct22A N OtherCapacityDays Nov22A N OtherCapacityDays Dec19A N...

Hi Dave - thanks for your reply. I couldn't agree more - it is hard to follow. What we are trying to calculate is per person per month a percentage load of how much someone is utilised so if they have capacity they will be under 1 e.g. 0.70, if they are over it will be 1.something

the fields we are grouping on are Month and Person

Hi Arnelgp - Thanks for your reply. demand is whats being divided and only if capacity is greater than zero so unless there is a situation whereby there is the same amount of holiday as there is capacity, that's the only way I'm seeing it could be divided by zero.

Hi - I have a system I have inherited, which after about of year of no problems has a query that is now resulting in an overflow error that I cannot get to the bottom of. The problem seems to stem from an expression field... % Load: Round(IIf(Sum(IIf([Data...