I apoogize in advance for the messyness of this expression but here it goes:
=IIf(Format([Delivery To],”yyyy mm”)=Format([Month2],”yyyy mm”),([NoCars]-[Past]-[Month1Eq]),IIf((IIf(IsError(IIf((Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”)) And (IIf([Month1Eq]-[Balance]<0,IIf(Format([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0))),0,IIf(Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”) And (IIf([Month1Eq]-[Balance]<0,IIf(Format([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0)))+IIf(Format([Month2],”yyyy mm”)<+Format(Now(),”yyyy mm”),[Month2Cars]))<[Month2Cars],[Month2Cars],(IIf(IsError(IIf(Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”) And (IIf([Month1Eq]-[Balance]<0,IIf(Format([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0))),0,IIf(Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”) And (IIf([Month1Eq]-[Balance]<0,IIF(Format ([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0)))+IIf(Format([Month2],”yyyy mm”)<+Format(Now(),”yyyy mm”),[Month2Cars]))))
I am getting the following error when I try to run it:
=IIf(Format(
The expression you entered contains invalid syntax
You may have entered an operand without an operator.
I'm thinking its something with how I wrote the "AND" portion of the expression. I am pretty confused now and not sure where to start as far as diagnosing the problem.
=IIf(Format([Delivery To],”yyyy mm”)=Format([Month2],”yyyy mm”),([NoCars]-[Past]-[Month1Eq]),IIf((IIf(IsError(IIf((Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”)) And (IIf([Month1Eq]-[Balance]<0,IIf(Format([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0))),0,IIf(Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”) And (IIf([Month1Eq]-[Balance]<0,IIf(Format([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0)))+IIf(Format([Month2],”yyyy mm”)<+Format(Now(),”yyyy mm”),[Month2Cars]))<[Month2Cars],[Month2Cars],(IIf(IsError(IIf(Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”) And (IIf([Month1Eq]-[Balance]<0,IIf(Format([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0))),0,IIf(Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”) And (IIf([Month1Eq]-[Balance]<0,IIF(Format ([Month2],”yyyy mm”)>=Format([Delivery From],”yyyy mm”),[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0)))+IIf(Format([Month2],”yyyy mm”)<+Format(Now(),”yyyy mm”),[Month2Cars]))))
I am getting the following error when I try to run it:
=IIf(Format(
The expression you entered contains invalid syntax
You may have entered an operand without an operator.
I'm thinking its something with how I wrote the "AND" portion of the expression. I am pretty confused now and not sure where to start as far as diagnosing the problem.
