tanj1035
asked on
SSRS Row visibility
Hi, please see the attachment of my table. I may need your help on the row "Trending % " visibility.
In this table, there are a few expressions
1) 1st column - 1st row: if it is a current month (not a full month), the field will show * with monthname. i.e. April *
=iif (monthname(month(today())) = Fields!MonthName.Value, Fields!MonthName.Value+"*" , Fields!MonthName.Value)
2)2nd, 3rd, 4th, 5th column - 2nd row: it calculates the tranding % from first month and the second month.
i.e.
=(Last(Fields!Deal.Value)- First(Fiel ds!Deal.Va lue))/Firs t(Fields!D eal.Value)
3)5th column - 1st row: lookup function from 2 datasets
=Lookup(Fields!MonthName.V alue,Field s!MonthNam e.Value,Fi elds!Uniqu eDeals.Val ue, "UniqueOpportunity")
What I need to do :
I want to hide trending % row when it is not a full month, since the calculation does not make any sense. As you see -86.49% is based on a partial April data.
I still want to show trending % row when 2 months are full month, since the calculation is reasonable. i.e. February , March.
Many Thanks!
Capture.JPG
In this table, there are a few expressions
1) 1st column - 1st row: if it is a current month (not a full month), the field will show * with monthname. i.e. April *
=iif (monthname(month(today()))
2)2nd, 3rd, 4th, 5th column - 2nd row: it calculates the tranding % from first month and the second month.
i.e.
=(Last(Fields!Deal.Value)-
3)5th column - 1st row: lookup function from 2 datasets
=Lookup(Fields!MonthName.V
What I need to do :
I want to hide trending % row when it is not a full month, since the calculation does not make any sense. As you see -86.49% is based on a partial April data.
I still want to show trending % row when 2 months are full month, since the calculation is reasonable. i.e. February , March.
Many Thanks!
Capture.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
=iif (monthname(month(today()))
in the expression. And it works!!
Many thanks.