Finance | Project Operations, Human Resources, ...

Report designer Hide column when run certain period

(1) Share

Report

Posted on by BassFad

155

Hi,

I'm currently building a report where, if someone runs it for a period like October 1, 2024, I expect it to hide all columns with a period after 10 due to P<=B. However, it's not hiding those columns in 2023 due to my formula Base-1. I assume this is because the formula doesn't only read the month (period) but also the year in the P<=B condition.

How can I adjust the formula to also hide the 2023 period?

Thank you

I have the same question (0)

All responses (3)

Answers (0)

Ramit Paul 22,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

As far as I am aware, MR columns aren't hidden based on conditions, however if you know something like this or saw some blogs, I am open to learn and then help on the same if possible.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

Your assumption is correct - the Print control conditions are period-based only. I don't see a way to apply a Year condition on the periods as you're limited to using only the conditions in the list.

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

There may not currently be a standard functionality conditional on year that meets your needs. You can try custom development to meet your needs. If you don't have a developer, you can seek help from Microsoft partners who will provide you with customized services. For details, please refer to this link: Find the right app | Microsoft AppSource.

Best regards,

Kevin

Was this reply helpful? Yes No