You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

IFTHEN HeadingValue

edited Feb 19, 2026 10:07AM in Narrative Reporting 2 comments

Summary:

Use IFTHEN with HeadingValue to populate values from a specific row when the account is = 'X', possible?!

Content (please ensure you mask any confidential information):

Hi, to minimise the number of hidden rows in a report I had the idea of using a single row with children of / descendants of and then using IFTHEN function in various formula rows to pull just the values in question, but my problem is that IFTHEN does not seem to work with heading value, can anyone tell me if this should work and what is incorrect with; -

IFTHEN(HeadingValue, "Grid1", "Account", 1) = 'K123456", [1], 0)

Assuming Grid1 is my current grid, Account is one of the dimensions in row 1, row 1 has the data that I want.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!