RichYute Member

Sorry for my extremely late reply on this, but the solution worked!.

@GrantSmith This sounds like a workable solution. I will give it a go and comment back on the result. Thanks, Rich

Hi Guys, I wasn't expecting such a quick response from the community, so first let me say thanks. Clearly I am not all that knowledgeable as I would like to think either. Maybe a question for @GrantSmith ...I understand that Formula tile could be used, but this in my opinion won't help to address the monthly changes in fx…

Hi Mark, Your method worked, but the under-lying issue for me was that I was a filtering (Date) which seems to have change format during transformation and as result messed everything up for me. Domo is so powerful and unforgiven, but thanks again for your time and effort.🍻

Hi Mark , First thanks for your quick reply and also for showing me yet another example...For filter let me show you what I have instead - see link - https://www.screencast.com/t/LYIdrV1V