This case statement works (29 total passes of SQL)when I run the SQL generated by MSTR; however, on the MSTR report the value shows as zero(0). The actual values showing when I query the temp tables in Oracle are long like 0.370419202, 0.260209601 and I'm thinking maybe there are too many decimal places. I tried to TRUNC within the Case statement without any changes. Can someone suggest a fix??
THANKS!!!
ApplySimple("CASE WHEN #0>1.95 THEN 1.85 WHEN #0<1.95 AND #0>1.4 THEN #0-.15 WHEN #0<1.4 AND #0>.75 THEN #0 WHEN #0>.75 THEN #0+.20 WHEN #0<.75 THEN #0+.15 ELSE 0 END", [D - Sales Index])
THANKS!!!
ApplySimple("CASE WHEN #0>1.95 THEN 1.85 WHEN #0<1.95 AND #0>1.4 THEN #0-.15 WHEN #0<1.4 AND #0>.75 THEN #0 WHEN #0>.75 THEN #0+.20 WHEN #0<.75 THEN #0+.15 ELSE 0 END", [D - Sales Index])