Thanks very much for sharing that. Will have to look at home later since this port is firewalled at work.

This works great, if I want to display just one column. However I couldn't get it to display three columns for: current value, target and then the difference.

I've created this analysis now with the advice I received and it works fine. What I did was, I created 8 presentation variables and then 8 custom columns to handle each of the variables. Out of curiosity, is there also a way to display this information in rows instead of columns. I mean, is it possible to use all 8…

True, this is not particularly user friendly but valuable to know nonetheless. Thank you!

Thank you - wIll try that at the office tomorrow. I suspect the next obstacle will be creating custom columns with correctly functioning formulas. Through this is simple subtraction, so hopefully it should be straightforward.

Do you mean that I can fill one presentation variable with several values? It is matter of only 7-8 values that need to be compared. Can I do this with one variable or would I need a separate one for each value?

My apologies. My question wasn't particularly clear I realise now. The issue is that the database only contains the current numbers, but the target number are not in there. So I would have to add the target numbers via prompt or in a custom column somehow.

Yes, it's a text field they are using for input. I do not have access to write to the database directly. Fortunately, considering my current level of skill

That works great. Thanks very much, Federico.

Thank you to everyone who responded with their helpful comments. I ended up having the user input all the address pieces separately and then shuffling the bits inside of filters. So, to be fair I'll mark the correct answer to be the one from Manoj. Thanks again!

Is there a way for me to actually test if the user entered a value for the presentation variable (at the prompt) before I pass it on to the filter? That would make filter logic much simpler, if I could just not use those column filters where the user did not input a value.

This is true. It might indeed be a better idea to prompt for the country, city, street number and street name separately and then create my own filters. I'm trying to do this now but my next issue is how to ignore those prompt fields that the user leaves blank. The database has columns for each of the pieces of info:…