So what I'm missing is that it shouldn't divide by the "grand summary" but only by the row summary, meaning by the month total.
So in month november I have 6 lead w status in progress and in total for the month of november i have 28 records.
so the formula should calculate 6/28-> 21.4% now the formula gives me 1% ->since it is calculating 6/800(total year value).
See screenshots.
Can someone help me change the formula that it will always take the current month's total instead of the grand summary total of the whole year?
Many thanks,
Philipp
2 réponses
