Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

If else possibility in universe designer

Hello

I am trying to implement If else logic in universe designer, but unfortunately I ended up getting error.

Below is my formula

If IsNull(@Select(abc\col1))

then 0

else @Select(abc\col1)

I am getting error From keyword not found where expected.

I am wondering whether if else logic possible in universe designer or it should only be implemeted in WEBI.

Thanks for your help.

Regards

Siva

Tags:
Former Member replied

Hi Siva  ,

We need to understand , universe supports database functions to which universe is pointing .

If you want to write logic like above ansi supported syntax will be

Original systax :-

If IsNull(@Select(abc\col1))

then 0

else @Select(abc\col1)

New syntax

case when (@Select(abc\col1)) is null then 0 else @Select(abc\col1) end

You can also handle the same using database specific finctions like NVL or coalesce() just go through available function list .

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question