How To XDetail: IIf([Pending Bill Amounts]=0 & <0 & >1,Null,[PurDetail])

[aamer]

XDetail: IIf([Pending Bill Amounts]=0 & <0 & >1,Null,[PurDetail])



How to Write this correctly

[pbaldy]

It doesn't make any sense to me. What amount would be excluded if you test for all 3? In words, what do you want the test to be?

[ArviLaanemets]

I'd prefer (as a rule, arithmetical/logical expressions work faster then functions)

([Pending Bill Amounts]>0)*([Pending Bill Amounts]<=1)*[Pending Bill Amounts]

NB! In case the number of logical expressions in formula is odd, you have to multiply the result with (-1).

Edit: I missed that you wanted Null returned in case False. So:

Iif(And([Pending Bill Amounts]>0,[Pending Bill Amounts]<=1),[Pending Bill Amounts],Null)

[aamer]

There is code is giving error

Iif(And([Pending Bill Amounts]>0,[Pending Bill Amounts]<=1),[Pending Bill Amounts],Null)

[aamer]

zero value should be excluded and to show as null value

[pbaldy]

That's Excel. Try

Iif([Pending Bill Amounts]>0 AND [Pending Bill Amounts]<=1),[Pending Bill Amounts],Null)

Though you may want to check your logic.