Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

If Formula with a range?

I have 2 measures.  Measure 1: Time = DATEDIFF([ERDAT],[CLDAT1].[Date],DAY)   Measure 2:  Target = IF([Time]<=21,"in time","overdue")   If CLDAT1 is empty than Measure 2 shows as well "in ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    If CLDAT1 is empty does that make Time empty?

    If so, try:

    Target = IF(ISBLANK([Time]),BLANK(),IF([Time]<=21,"in time","overdue"))

    Or

    Target = IF(ISBLANK([Time]),"in progress",IF([Time]<=21,"in time","overdue"))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If CLDAT1 is empty does that make Time empty?

If so, try:

Target = IF(ISBLANK([Time]),BLANK(),IF([Time]<=21,"in time","overdue"))

Or

Target = IF(ISBLANK([Time]),"in progress",IF([Time]<=21,"in time","overdue"))