if value when nil is left blank, does it return blanks or is it in another format

[philc]

Basically I am trying to set up a formula that will calculate a blank score (i.e. the field Value when Nil is left blank) by adding 100, but where the field is blank nothing is being returned.

The formula I has set up is:

if ([[Knowledge Articles Timeliness]] = "" ) {

(100+[[Knowledge User Comments Responses]]+[[Knowledge Usefulness Quality]])

} else {

if ([[Knowledge User Comments Responses]] = "") {

([[Knowledge Articles Timeliness]]+100+[[Knowledge Usefulness Quality]])

} else {

if ([[Knowledge Usefulness Quality]] = "") {

([[Knowledge Articles Timeliness]]+[[Knowledge User Comments Responses]]+100)

} else {

[[Knowledge Articles Timeliness]]+[[Knowledge User Comments Responses]]+[[Knowledge Usefulness Quality]] }
}}

So where the value is blank, I want a score of 100 added to another formula indicator.

All indicators listed are formula types.

[Dave Smith1]

I've no idea where that code is used, but as an observation... in databases, there's a difference between field == "" and field IS NULL.   Perhaps there's some method or function that checks for it being empty, rather than containing blank.

Is there anyplace you can write out the field value?   i.e.: check for "" then write out a word "blank" to test your logic?

[philc · Accepted solution]

Worked Resolution

Having tried multiple formulas to return a value of 100 where the original score was showing as a blank (i.e. 0/0 calculations) - all
of which failed to return any value (or text as suggested by Dave), I decided to create two formula indicators for each of the three measures:

The first (primary) to return the score as a percentage using the formula:

([[Number of Unexpired Published Knowledge Articles]]/[[Number of Published Knowledge Articles Owned]])*100

And a second to perform a similar calculation but setting this one to return the value of 100 for each blank score returned, using the formula:

[[Number of Published Knowledge Articles Owned]]>0 ? (([[Number of Unexpired Published Knowledge Articles]]/

[[Number of Published Knowledge Articles Owned]])*100) :100

These secondary indicators were then added together to provide the combined scores to give a maximum value of up to 300; taking
account of the percentages returned, as well as calculating the value of 100 for each blank score returned by the primary indicators..

This achieved the desired result, with four columns shown in a Pivot widget, the first 3 showing blanks where there was no score, and the
fourth column showing the accumulated values and calculating any blank entries with 100 as required.