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.
,
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