Forum Discussion

MJ1705's avatar
MJ1705
New Contributor II
17 days ago

Parameter Issue in Cube View Formatting

Hi,
So I am using one Parameter in Cube View Formatting where I am facing some issue.
So there are 11 Forecast Scenario in my application.
Fy25Fcst1, Fy25Fcst2 through Fy25Fcst11.

My formatting rule is set in this way-
 If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst2) Then 

***Condition***

End If


This is working perfectly for scenario 2 through 11 but even if I select 10, this shows the result of 1 as well.
To negate this I tried to replace the condition with 

 If ([|!Scenario_WaterFall_MemberList!|] EndsWith Fcst2) Then 

But this is not working. Can anyone let me know what can be done to resolve this issue. Thanks.

JackLacavaKrishna 

Application Properties
Cubes
Metadata
  • victortei's avatar
    victortei
    New Contributor III
    15 days ago

    I’m not sure how you're nesting your If statements, but I’d recommend starting by checking if the value is Fcst10, Fcst11, or Fcst12 first in your conditional checks. This will ensure that you evaluate the exceptions early on (10, 11, and 12). Something like this:

    If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst12)  Then
    Condition
Else If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst10)  Then
    Condition
Else If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst11)  Then
    Condition
Else If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst1)  Then
    Condition
	... 
'Check Fcst 2-8

Else If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst9)  Then
    Condition	
End If