Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have text box with this calculation on below
count( {<[Date] = { "$(='>=' & monthstart(max([Date])) & '<=' & monthend(max([Date])))" }
, [Status] = -{''Status1, 'Status2', 'Status3', 'Status4'}
, [Result] = {'On Target'}
>} distinct [Item ID] )
/
count( {<[Date] = { "$(='>=' & monthstart(max([Date])) & '<=' & monthend(max([Date])))" }
, [Status] = -{''Status1, 'Status2', 'Status3', 'Status4'}
>} distinct [Item ID] )
I want the number appear in RED if lower than 0.90 and other in GREEN
How to write the expression
Thank you,
if(expression < .9, red(), green())
or
if(Column(1) < .9, red() green())
I already set the expression like you said
but value appeared in code of color not value of calculation