Hi All,
I am trying to create a logical column using below three physical columns
i am providing the column values;
total receivables (data type: double) = 21476.15
tot_bill_M (data type: double) = 3276.03
tot_bill_M_1 (data type: double) = 18200.12
case when (ifnull(total receivables,0) - ifnull(tot_bill_M,0) - ifnull(tot_bill_M_1,0) ) <= 0, 0, another condition to be performed
but here first condition less than or equal to 0 should be have met and should publish as 0 in obiee reports.
But here it is going to second condition for calculation.
is there anyway we can perform this?