Conditional Parameter based on group level 1

[adahawy]

Hi
i am trying to create a parameter field that changes its value depending on the group level, not able to find the correct syntax.
The context that i am working in is as follow.

i have a report with 5 group levels

i want to insert a parameter field in each group that would behave as follow

if current group level <= 4 then 1
else 0

all that i am looking for is the syntax for the condition part ( current group level <= 4)?

thanks

 

[IanWaterman]

Not clear what you are trying to achieve. Please provide more details. Please show sample data and what you want it to look like

Ian

 

[adahawy]

Hi Ian

sorry, i think i used the term conditional parameter when i meant conditional formula field

In the design view , i have 5 group levels:
GH1 Device
GH2 Year
GH3 Quarter
GH4 Month
GH5 Product

in each group i have 2 fields:

Revenue is a summary field
@Flag is a formula field



i am looking for the syntax to write in the @Flag formula field so that when i insert @Flag in all 5 group levels it would return 1 if GH# <= 4 and would return 0 if GH# = 5 ( GH# means Group header number)

i.e
when GH#=1 then @Flag =1
when GH#=2 then @Flag =1
when GH#=3 then @Flag =1
when GH#=4 then @Flag =1
when GH#=5 then @Flag =0

in the preview it would look something like, i have used underscore to replace empty spaces

Device Year Quarter Month Product Revenue @Flag
Tablet_________________________2000_____1
_____2013_____________________2000_____1
___________Q1_________________2000_____1
__________________1___________2000_____1
_______________________Apps___2000_____0
_______________________Games_2000_____0
__________________2___________2000_____1
_______________________Apps___2000_____0
_______________________Games_2000_____0

thanks

 

[IanWaterman]

Just place a formula in each header

Place this in headers 1-4
@flag1
1

Place this in header5
@flag0
0

Ian