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

In reports evaluate a selected POV member and use a different data set if it meets criteria

in Planning 4 comments

I have a report with scenario in the POV, and the function CurrentPOV in Col D.

Depending on what is selected as the Scenario in the POV, I want to return different values.

If I enter 'IfThen(HeadingValue("Grid 1","Scenario",D)=Actual,[2],[3])' into a Text row, it resolves as 'IfThen(Actual=Actual,[2],[3])' which is not unexpected, but if I put it in a formula column I get a syntax error 'Grid "Grid 1" formula row 5 has a syntax error at or after "HeadingValue" at the character position 8.'

Is it even possible to evaluate based on POV selection?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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