Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sbojovic
Contributor
Contributor

Problem- Invalid dimension grouping

if(WildMatch(Kategorija,'*reprezentacija*'),'Zakonski neodbitno',If(WildMatch(Kategorija,'*putnicka vozila*'),'Zakonski neodbitno',if(WildMatch(Kategorija,'*Uvoz robe*'),'Ostalo',if(WildMatch(Kategorija,'*garancija*'),'Ostalo','Potencijalno odbitno')))

2 Solutions

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi Sbojivic,

It looks like you are missing a ')' at the end for closing your first if statement.

If(WildMatch(Kategorija,'*reprezentacija*'),'Zakonski neodbitno',
    If(WildMatch(Kategorija,'*putnicka vozila*'),'Zakonski neodbitno',
        If(WildMatch(Kategorija,'*Uvoz robe*'),'Ostalo',
            If(WildMatch(Kategorija,'*garancija*'),'Ostalo','Potencijalno odbitno'
             )
        )
     )
)

Jordy

Climber

Work smarter, not harder

View solution in original post

JordyWegman
Partner - Master
Partner - Master

If your problem is solved, please mark it as solved.

Work smarter, not harder

View solution in original post

5 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Sbojivic,

It looks like you are missing a ')' at the end for closing your first if statement.

If(WildMatch(Kategorija,'*reprezentacija*'),'Zakonski neodbitno',
    If(WildMatch(Kategorija,'*putnicka vozila*'),'Zakonski neodbitno',
        If(WildMatch(Kategorija,'*Uvoz robe*'),'Ostalo',
            If(WildMatch(Kategorija,'*garancija*'),'Ostalo','Potencijalno odbitno'
             )
        )
     )
)

Jordy

Climber

Work smarter, not harder
sunny_talwar

Why don't you simplify it to this

Pick(WildMatch(Kategorija,'*reprezentacija*', '*putnicka vozila*', '*Uvoz robe*', '*garancija*') + 1,
'Potencijalno odbitno', 'Zakonski neodbitno', 'Zakonski neodbitno', 'Ostalo', 'Ostalo')
sbojovic
Contributor
Contributor
Author

Thank you, that's right.
sbojovic
Contributor
Contributor
Author

Thank you for your suggestion, I'll try that way as well.
JordyWegman
Partner - Master
Partner - Master

If your problem is solved, please mark it as solved.

Work smarter, not harder