Need to group but no options

[brecat77]

my formula reads like this but i need to group by this formula and it does not show up to group by it.

if GroupName ({oe_line_1000.budget_code}) startswith "P"

then

left(GroupName ({oe_line_1000.budget_code}),5)

else

left(GroupName ({oe_line_1000.budget_code}),4)

 

[brecat77]

ok, i figured out that i cannot group by a group. what i need to do is group by the first 5 places if it begins with a P and by the first 4 if it does not.

 

[brecat77]

fixed

 

[lbass]

Please explain what you did so the post becomes useful to others. Generally you should use the field itself rather than the groupname in formulas. So far, I have never found a reason to use a groupname in a formula for anything.

-LB

 

[brecat77]

i ennded up using the following formula and it worked

if {oe_line_1000.budget_code} startswith "P"

then

left({oe_line_1000.budget_code},5)

else

left({oe_line_1000.budget_code},4)