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(Fields!Deal.Value))/First(Fields!Deal.Value)

3)5th column - 1st row: lookup function from 2 datasets
=Lookup(Fields!MonthName.Value,Fields!MonthName.Value,Fields!UniqueDeals.Value, "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
tanj1035Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nico BontenbalCommented:
I can't tell for sure without your data and your report design but what happens when you use this formula for the Trending row:
=iif (monthname(month(today()))= Last(Fields!MonthName.Value);"";(Last(Fields!Deal.Value)-First(Fields!Deal.Value))/First(Fields!Deal.Value))

Open in new window

This should hide the value from the row when the last month is the current month right?

If this works then you should be able to hide the row by setting the visible (or hidden actually) property of the row to:
=monthname(month(today()))= Last(Fields!MonthName.Value)

Open in new window


I haven't tested this because that would require me to replicate the design of your report. If you want me to look into it in detail it's much more efficient if you upload the report here. Be careful not to upload any sensitive design or data! You might want to make some changes to the design of the report before you upload it. Don't worry about including any data, I can make some test data myself.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tanj1035Author Commented:
Thanks, based on your suggestions, I used

=iif (monthname(month(today()))= Last(Fields!MonthName.Value), true, false)

in the expression. And it works!!

Many thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.