Forum Discussion

MJ1705's avatar
MJ1705
New Contributor II
3 months 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...
Application Properties
Cubes
Metadata
victortei's avatar
victortei
New Contributor III
3 months 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