how to separate weekday/weekend calculation in tableau?

Question

I have created a calculated field identify between weekday/weekend

IF

    DATENAME('weekday', [Date]) = "Saturday"

OR DATENAME('weekday', [Date]) = "Sunday"
 THEN "Weekend" 

For day calculation

INT(SUM(
IF [Day] = 'Weekday'
THEN [Number of Records]/22

ELSE
[Number of Records]/8 

END )) 

Average Calculation:

[Number of Records] * 1.2 > [Average]

OR 
 

[Number of Records] * 0.8 < [Average] 

I am getting some wrong calculations based upon the above calculations 

Answer 1

The average calculation should look like this:

{FIXED [Day]: AVG([Sales])}

Outlinear Calculation:

[Sales] > 1.2 * [Average] OR [Sales] < 0.8 * [Average] 

If you want to check more about calculated fields then learn Tableau

Also, do watch the YouTube video given below to get started with Tableau training.