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 function on a formula column in Narrative Reporting

Accepted answer
74
Views
5
Comments
edited Jul 3, 2021 4:58PM in Narrative Reporting 5 comments

Summary

IFTHEN function on a formula column in Narrative Reporting

Content

Hello,

I am trying to use IFTHEN function on a formula column. I need my column to have value based on Period member.

If Period = 'Mar', Col[B],Col[A] - If Col B has period Mar, display col B values in formula column else display col A values.

IFTHEN(Col[B]='Mar',[B],[A])

But, Period is not considered is in the IFTHEN function.

Any thoughts on how this can be achieved.

Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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