formula taking long time to execue

Hi there

Please can you provide more details?

Can you also make sure that your data model is using a star schema with tables and dimensions.

There is a lot of things that could affect the query, and following best practice principals first will allow for things to run really quickly.