Actaul Forecast problem

Question

Hi ,I have below columns in my obiee report

Calendar Date , Actual, Forecast

Now i want the required result like - Actual and forecast AUM shouldn't show for the same period. AUM should show from actual if available and it actual isn't available, show forecast. If neither are available show nothing  on the same dashboard page .. how to do this in obiee?Plz let me know.reply asap....

regards,

Sony

Gianni Ceresa · Answer

A detail first: "reply asap" in a community forum where users are investing their own personal time and aren't paid to post any reply is considered unpolite, try to avoid it in the future (or hire a consultant and he will be paid to reply "asap").

Did you try with a CASE WHEN ? It's the IF-ELSE in an OBIEE analysis.