Can someone help me with the formula for this condition ? Please

[Mirzohid]

If there are less than 20 sales in a month, write 20. If greater than 20 sales, write greater one. For example: January has 17 sales, accept that as 20, if February has 25 sales, accept that as 25. And You can see the sum of sales in two months is 45. Because you accepted first month's sales as 20 and next month's sales as 25. And Now I need the sum of each month's accepted sales for the whole time period not for 2 months. Can someone help me with the formula for this condition ? Please 

[jyothis_m · Accepted solution]

I think a single formula won't solve all your requirements. Please elaborate more on your requirement

for the first part you can create a Virtual Column [Accepted Sales] with formula

IF([SALES]<=20,20,[SALES])

to get sum of all [Accepted Sales] you can use the expression

SUM(TableName[Accepted Sales])