Finance | Project Operations, Human Resources, ...

Report designer Hide column when run certain period

(1) Share

Report

Posted on by BassFad

123

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

All responses (3)

Answers (0)

Kevin Xia Microsoft Employee on at

Like (0)

Report

Report designer Hide column when run certain period

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
Suggested answer

Frank Hamelly | MVP... 46,226 Super User 2024 Season 2 on at

Like (0)

Report

Report designer Hide column when run certain period

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.
Ramit Paul 22,295 Most Valuable Professional on at

Like (0)

Report

Report designer Hide column when run certain period

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.