Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Dear Experts,
i am trying to display the page only Tier1 values for three months for that i am using below expression
=only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}
if ((RAG_RATING_CD) = 'R', '1'))
Here im getting Tier1 including the blanks, i just want to remove the blanks
i need help on restrict the page to only Tier1 values any suggestion
for reference i have attached image
Thanks In Advance,
Niranjan
May be like attached?
I guess use an if statement for all your expressions except for [Tier Status] expression
=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0, Expression)
Hi Sunny,
Thanks for your reply
on expression column what you want me to write
=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0, Expression)
I guess all remaning expressions. How many do you have in total?
its will change based on MonthYear selections
you mean to say like below mentioned
suggest me if im wrong
=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0,
only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if ((RAG_RATING_CD) = 'R', '1')))
Thanks,
Niranjan
=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0,
Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))
with above expression still im getting blanks
Thanks,
Niranjan
hi,
Load
if (Fieldname <> 0,FieldName) as Fieldname
Hi Chanty,
its not actually blanks
im trying to displaying only Tier1(pink) columns
Thanks,
Niranjan
Dear Experts, Any suggestion
You need to apply Sunny's suggestion to all the expressions. To suppress a row, all the expressions must evaluate to exactly zero, or null. If any do not, then the row will be displayed.