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
Hi,
May be try this for all your expression (already sunindia suggested) except which is showing value '1', i think middle expression
1st Expr: if(
only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}
if ((RAG_RATING_CD) = 'R', '1')) =1, 1st Expression)
2nd Expr :
if(
only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}
if ((RAG_RATING_CD) = 'R', '1')) =1, 2nd Expression)
like wise other expression except this one
only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}
if ((RAG_RATING_CD) = 'R', '1'))
Hi Jonathan,
Good Morning, Thanks for your reply
i have tried but still im getting same, i have attached sample application
please suggests me where im doing wrong
Best Regards,
Niranjan
Hi Settu_Periasamy,
Good Morning, Thanks for your reply
its bit confusing me do you want me to write all the conditions at one place
i have attached sample application
suggest me the right way to do ??
Best Regards,
Niranjan
May be like attached?
Thanks so much its working fine