Skip to main content
M
MJ1705
Newcomer
February 5, 2025

Parameter Issue in Cube View Formatting

  • February 5, 2025
  • 1 reply
  • 0 views

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 

1 reply

V
victortei
Newcomer
February 7, 2025

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

 

Terms & ConditionsAccessibility statement