Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
how do you add extra numbers to the formula just to change data for one month and not disturb other values?
I have the count(leads) wrong for the month of Feb 2021.
I want to add +2000 to the existing count and also not alter other numbers.
For example, I tried formula with if statement:
count(if(year=2021 and month=Feb and lead='Funnel',lead))+2000
This gives me the right value for Feb2021 but the wrong values for other months.
Can someone give me a better solution for this?
Thanks a lot
Best Regards,
Neeraja