Skip to Content
0

Unable to create logic in IDT

Dec 26, 2016 at 05:47 PM

48

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mauro Federico Rodríguez Mangold Dec 27, 2016 at 03:08 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded