Skip to Content

Unable to create logic in IDT

Dec 26, 2016 at 05:47 PM


avatar image
Former Member

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 ,


idt-error.jpg (123.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

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.



10 |10000 characters needed characters left characters exceeded