cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to have if else with blank member

Former Member
0 Likes
179

Hello, quick question. How do I set up an if else statement, so that if A1=Yes, then it should show plan category, but else show blank member. if else works fine if it's just if A1=Yes, plan, else actual(both plan and actual are category member dimension) . But showing this blank doesn't seem to be possible. please advise.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Likes

Where do you want to have if else ?

Former Member
0 Likes

In the epmolapmember(row axis)

former_member186338
Active Contributor
0 Likes

in epmolapmembero only valid member id can be used!

former_member186338
Active Contributor
0 Likes

P.S. Instead of [Blank Member] you can use some real dummy member!

Assuming that dummy member contain no data! And you can rename the dummy member to " " in report settings...