Forum Stats

  • 3,826,865 Users
  • 2,260,714 Discussions
  • 7,897,108 Comments

Discussions

PBCS: Data in form

3235756
3235756 Member Posts: 129
edited Sep 1, 2016 9:18AM in Planning and Budgeting

I explain the steps that I have followed:

I have defined the "ESCALA" list.

pastedImage_2.png

pastedImage_4.png

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"

pastedImage_7.png

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

pastedImage_5.png

     ** 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

pastedImage_8.png

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?

Tagged:

Best Answer

Answers

This discussion has been closed.