Help with IIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tyring to get:
If July data is zero, enter August data, if August data is is greater than o
then do august data - july data ,otherwise august data + july data. I have
entered the below but it asks me for parameter values. Can anyone help?

Hours:
IIF(ISNULL([JULYYTD]![TIME_DURATION]),[AUGUSTYTD]![TIME_DURATION],IIF([AUGUSTYTD]![TIME_DURATION]>0,(([AUGUSTYTD]![TIME_DURATION]-[JULYYTD]![TIME_DURATION])),([AUGUSTYTD]![TIME_DURATION]+[JULYYTD]![TIME_DURATION])))
 
You did not say what "parameter values" it ask for.

You do realize that null is not the same as zero. Zero is an actual value
whereas null is the absence of any data.
 
Back
Top