PBCS: Data in form

3235756

I explain the steps that I have followed:

I have defined the "ESCALA" list.

I have created a "RESULTADO"  member in "Partidas" dimension with this formula:

[OpenInputValueBlock]

IF ("R20">200)

"RESULTADO"=[Escala.A];

ELSEIF (("R20">50) OR ("R20"<200))

"RESULTADO"=[Escala.B];

ELSEIF ("R20"<50)

"RESULTADO"=[Escala.C];

[CloseInputValueBlock]

I have created a form with the "RESULTADO" row. I viewed the data and all cells with the value "DEFICIENTE"

I access to "ESCALA" list to complete the information that I mark in yelow:

     ** I add this infomation because I want that if the values are blank,  the system displays the text "--". Is correct this funcionality that I want for this option?

I have created a "RESULTADO B"  member in "Partidas" dimension with this formula:

[OpenInputValueBlock]

IF ("R20"==200)

"RESULTADO B"=[Escala.C];

ELSEIF ("R20"==50)

"RESULTADO B"=[Escala.B];

ENDIF

[CloseInputValueBlock]

I add  the "RESULTADO B" row at form.

I refreshed the data base

Why the RESULTADO row doesn't refresh with --?

Are there other setup for "RESULTADO" or "RESULTADO B" row,  if I want that the system displays the cells in blank or with value "--" when the values in other rows are blank?

JohnGoodwin

Here is an example

Smart List

Missing drop down label set to "--"

Missing form label set to "Drop Down Setting"

Member with Smart List assign and formula =

Form

Cheers

John

JohnGoodwin

Here is an example

Smart List

Missing drop down label set to "--"

Missing form label set to "Drop Down Setting"

Member with Smart List assign and formula =

Form

Cheers

John

3235756

Thanks, I added the value #Missing at formula and, the form has the information like I want.