Skip to main content
D
Davy
Contributor
September 6, 2022

Why is 1S not formating pink (which is returned by u8#formula) ?

  • September 6, 2022
  • 3 replies
  • 0 views

Hi,

I have a u8#memberformula that I am trying to use for the first time - to format the background color of a cell.

I know that setting 

BackgroundColor = pink

will cause the cell to turn pink.

BackgroundColor = u8#memberfomula

my u8#memberformula has only one line:

Return "pink" 

For unknown reason, 1S is not formating my cells pink ??
(I assume the text "pink" is returned by u8#formula) 
I know my formula is executed by 1S because I put a debug statement in there and it is showing in Error Log that my formula is executed .

 

3 replies

D
DavyAuthor
Contributor
September 6, 2022

Davy_0-1662456934806.png

 

D
DavyAuthor
Contributor
September 6, 2022

Davy_1-1662456973513.png

 

D
DavyAuthor
Contributor
September 6, 2022

I tried using BackgroundColor =GetDataCell(u8#memberformula)

Or should I not use member formula, but use a finance business rule instead and pass this in Cell Format:

 BackgroundColor =GetDataCell("BR#[BRtoReturnPink" )
?

 

C
Cosimo
Contributor
September 7, 2022

Davy,

I don't think you can use a member name or GetDatacell to return the value "pink". What I would do is use a dashboard parameter example: BackgroundColor = |!GetBackgrounColor!| and then set the color name within the literal parameter. If the color changes based on data value, you can call an XFBR rule within the dashboard parameter, have the rule analyze the value for current cell POV and return the appropriate color code. I haven't tried the latter so not 100% sure it works but I do think it's possible.

Terms & ConditionsAccessibility statement