Skip to Content
avatar image
Former Member

Unable to create logic in IDT

Hi ,

Im trying to create a measure variable with below logic in IDT

Weighted Sales Volume= if [Object status] =('lost','Closed') then 0 Else ([Expected sales Volume] * ([Probability]/100))

where [Expected Sales volume],

[Object status],

([Probability] are measure objects.

Even tried to use the case condition but it throws error.

Universe is developed on top of Infosets by connecting SAP CRM.

Please suggest.

Thanks ,

Sudhir.

,
idt-error.jpg (123.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 27, 2016 at 03:08 PM

    Hi Sudhir,

    In IDT you must use SQL syntax, no BO syntax, I can suggest to try the following.

    sum(case when Table.column in('Open','Close') then crmd_opport_h.exp_revenue*crmd_opport_h.probability/100 else 0 end)

    I'm not sure which is the table and column that filters the open close, that's why I wrote table.column

    hope it helps.

    thanks

    Mauro

    Add comment
    10|10000 characters needed characters exceeded