If Statement for Prior Month

[JustinRamsey]

 I have a formula in a chart SUM({<Sales={Sales}>} if (InMonthToDate (OrderDate, Today(), 0), ValueEa)) that shows the cumulative sales of the current month. What I have been requested for is for the first 5 days of the month that value shows the prior month due to month end closing stuff. I'm stuck on this. 

I am assuming I need the if statement if(day(OrderDate)<=5,  NEWFORMULA, OLDFORMULA) but I am unsure of how to write the NEWFORMULA for the prior months sales. Any help would be appreciated. 

[JustinRamsey]

The if statement at the bottom should be typo on my part.

if(day(today())<=5

[Kushal_Chawda · Accepted solution]

@JustinRamsey  change your new formula to below

SUM({<Sales={Sales}>} if (InMonthToDate (OrderDate, Today(), -1), ValueEa))