Conditional text depending on what table data comes from?

[gautam.bakshi]

Hi There,

I have data being displayed from two tables(actual or predicted). What I do is I query both, sort by date and merge the results than print the latest results. It works perfectly if I have actual data it displays that, if I have predicted data then that gets displayed.

What I want to also do is notify my users that it’s a prediction but I’m unsure how to do this. I was thinking of looking at the result of the field then if it matches the most recent data in my prediction table then display “predicted” otherwise display “actual”. I understand conditions for a text area is what I need but I’m not sure how it can figure out where the data is coming from.

Any ideas?