The following does nt work. Can anyone tell me why?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

If ([2015 YTD Actuals KUSD] = 0, [2015 YTD Forecast KUSD],
 [CIP Status] = "Fully Validated", [2015 YTD Actuals KUSD],
If ([CIP Project Status] = "5M" or , [CIP Project Status] = "5Q" or [CIP Project Status] = "5H" ,([2015 YTD Actuals KUSD] + ( ([2015 YTD Actuals KUSD]/ [# of Actuals Imported 2015]) * ([# of Actuals Months 2015] - [# of Actuals Imported 2015]))),""), "")


Photo of Kiran

Kiran

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
You don't give us much to go on but I made some assumptions ...maybe this:

http://pastie.org/pastes/10281850/text


Knowing what does not work (syntax error, wrong result, path not taken etc) and the types of fields you are dealing with helps.

Also, you might want to consider using Formula Variables to break up the long parts of the formula into shorter parts.

Formula Variables
https://www.quickbase.com/help/default.html#formula_variables.html
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
This is a numeric formula. But some of your possible results are a " " which is a space and that is text.

To have a result be null, just leave out the

, " "