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