Object creation

[former_member203645]

I have an objects in CR, need to convert into Universe Object

if not isnull({SAT_NC.PAYMENT_DUE}) and {SAT_NC.PAYMENT_DUE}>0 then 1

else 0

My SQL is MS SQL SERVER 2008

I tried this way >>>>> CASE WHEN COALESCE(SAT_NC.PAYMENT_DUE,0) >0 then 1 else 0 END

I getting incorrect results. Please suggest me did I go wrong in creation of Object.

[Former Member]

Try this;

CASE WHEN SAT_NC.PAYMENT_DUE >0 And ISNOTNULL(SAT_NC.PAYMENT_DUE) then 1 else 0 END

DLN

[Former Member]

it woked, Here is another issue my %%% and reason for wrong result.

Here is my scenario

Universe Object called >>> Customer identity

Created a new Variable in webi based >>> count of customer Identity

count of customer identity is around 1500.

When I used in the report, the variable count of Customer Identity is splitted based on the Service ID(Set as section),Service Area(setas section),Union 12,Union 13.

Like if the column values of Count of Customer Identity is 188 then

(188/1550)*100= 12.12%

When I am calculating in Webi with a new variable Count of Customer Identity exists only once.

[former_member142702]

Can you provide an example of the incorrect results?

Regards,

Stratos