Issue

[NavinReddy]

Hi All,

i have two multiboxes with same name(Comp)

one multibox two levels

*.level1(Sublob)

*.level2(officer)

second multibox two levels

*.level1(sublob)

*.level2(Division)

Issue is

i have Soblob two fields banking ,commercial

if i select banking in lob Officer should appier

if i select Commercial in lob Division should appier

Help me some one issue

Thanks in Advance

Niru

[jagan]

Hi,

Try creating a dynamic Dymension like this

If(Only(sublob) = 'banking', officer, Division)

Hope this helps you.

Regards,

Jagan.

[#3]

Sounds like a conditional statement is needed.

Add conditional [Sublob] = 'banking' to dimension/expression officer

And conditional [Sublob] = 'commercial' to dimension/expression division

[NavinReddy]

Hi jagan,

but performance issue i never use if condition

Thanks

Niru

[#5]

Hi Niru

There is the above method. Or, if you are not attached to the multibox functionality wIthin the List Box Properties, on the 'Layout' tab there is a box where you can state a condition to hide/show a list box.  So for the Officer list box you would you a formula such as;

Sublob = 'Banking'

But the above reply is best if you wish to keep the multiboxes.

All the best

Steve

[NavinReddy]

Hi

I am not under standing ur logic

could you please send any attachment

Thanks

Niru

[NavinReddy]

I atteched sample application

if select sub lob =business bank ,officer will appier

if select sub lob =commrcial ,vertical will apper

same multibox

some one help me

Thanks

Niru

[NavinReddy]

Guys any idea....

[#9]

You can break it down, but you'll have to use 3 multi-boxes.

Have a look at the attachment

[#10]

I would use Jagan's suggestion - yes IF's can use a lot of resources when using in a formula.  However, that only really applies when using in a large straight/pivot table.  This formula is not run multiple times over 1000's of rows, this is run once on one simple formula - it won't have a relevant impact on performance at all.