Conditional text depending on what table data comes from?

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?

This topic was automatically closed after 70 days. New replies are no longer allowed.