Good day everyone,

I am playing with some test data now, and I have a question.

So I am using data that comes from Zoho Projects. I made a SQL query to combine 4 tables together and it all work fine.

Now this is an image of the test data.

I got all the data I want showing but looking to add something and can’t figure it out for the life of me.

I was wondering is it possible to make formula that only affect grand summary or only affect the subtotal (like the one for user’s name).

For example, I want to split the total worked time to flag normal amount of work hours and overtime. Let’s say the normal amount work week would be 10 hours.

To grab the overtime I used this aggregate Formula.

if("Query - Facturation"."Total heure paye" > 10,"Query - Facturation"."Total heure paye"-10,0)

To grab the normal hours I did this.

("Query - Facturation"."Total heure paye"-"Query - Facturation"."Overtime")

But as you can see in the table it run the formula on the grand summary and make it useless. I tried messing with ignore_filter or groupby but was not able to make it how I want.

Now If I remove all the rows that have multiple entry it works.

Very lost at this point. If any one as an insight or trick, please let me know.