Hello,
I have the below fields in my spreadsheet that I would like to place in a pivot table. I want to calculate the sales turn for the aggregated with the formula (BOH $/Sales $)*# of weeks in the month.
I have tried using an if statement in the calculated field =if(weeks in month>4, (BOH $/Sales $)*5, (BOH $/Sales $)*4) however this ends up multiplying everything by 5. Is there another way to accomplish this? Please advise!
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have the below fields in my spreadsheet that I would like to place in a pivot table. I want to calculate the sales turn for the aggregated with the formula (BOH $/Sales $)*# of weeks in the month.
I have tried using an if statement in the calculated field =if(weeks in month>4, (BOH $/Sales $)*5, (BOH $/Sales $)*4) however this ends up multiplying everything by 5. Is there another way to accomplish this? Please advise!
Month | Sales $ | BOH $ | Weeks in Month |
JANUARY | $13,443.00 | $4,950 | 4 |
FEBRUARY | $18,743.00 | $17,972 | 4 |
MARCH | $21,630.00 | $19,725 | 5 |
APRIL | $13,981.00 | $20,231 | 4 |
AUGUST | $23,200.00 | $19,904 | 4 |
SEPTEMBER | $23,420.00 | $19,886 | 5 |
OCTOBER | $17,217.00 | $24,933 | 4 |
NOVEMBER | $21,810.00 | $27,126 | 4 |
DECEMBER | $52,669.00 | $46,723 | 5 |
JANUARY | $84.00 | $90 | 4 |
FEBRUARY | $632.00 | $8 | 4 |
MARCH | $1,118.00 | $2,840 | 5 |
APRIL | $442.00 | $1,492 | 4 |
AUGUST | $2.00 | -$24 | 4 |
SEPTEMBER | $1,049.00 | $1,196 | 5 |
OCTOBER | $114.00 | $131 | 4 |
NOVEMBER | $685.00 | $18 | 4 |
DECEMBER | $1,776.00 | $1,838 | 5 |
FEBRUARY | $0.00 | $0 | 4 |
MARCH | $178.00 | $224 | 5 |
APRIL | $34.00 | $44 | 4 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>