6 Replies Latest reply on Apr 23, 2018 9:27 PM by Ritesh Bisht

# Calculation of MAT Sales

Hi there

I am trying to calcuate the sales MAT this is my formula but getting error message

expected closing parethesis for the expression starting at charater 4. Not sure what is causing the issue

IF ([Financial Period (Date formatted)] =>[Removal Financial Period Start ]

AND <=[Removal Financial Period End ])

THEN [Gross Sales Revenue]

END

• ###### 1. Re: Calculation of MAT Sales

Hello Mellisa,

Try

IF ([Financial Period (Date formatted)]  => [Removal Financial Period Start ]) AND ([Financial Period (Date formatted)] <= [Removal Financial Period End ]) THEN [Gross Sales Revenue]

END

OR

IF ([Financial Period (Date formatted)]  => [Removal Financial Period Start ]) AND ([Financial Period (Date formatted)] <= [Removal Financial Period End ]) THEN SUM([Gross Sales Revenue])

END

Regards,

Sudheer

• ###### 2. Re: Calculation of MAT Sales

Please note

Greater than equal to should be >= not =>

Now rest is easy Your case

IF ([Financial Period (Date formatted)] >= [Removal Financial Period Start ]

AND    [Financial Period (Date formatted)] <=[Removal Financial Period End ])

THEN [Gross Sales Revenue]

END

Please mark it as CORRECT/HELPFUL & close the thread so that it can help others as well

Thanks,

Ritesh

1 of 1 people found this helpful
• ###### 3. Re: Calculation of MAT Sales

The calculation goes like this:

IF ([Financial Period (Date formatted)]  >= [Removal Financial Period Start ]) AND ([Financial Period (Date formatted)] <= [Removal Financial Period End ]) THEN [Gross Sales Revenue] END

Hmm...Frankly speaking, I've noticed after Ritesh post.

Regards,

Sudheer

1 of 1 people found this helpful
• ###### 4. Re: Calculation of MAT Sales

Please mark it as CORRECT/HELPFUL & close the thread so that it can help others as well

Thanks,

Ritesh

• ###### 5. Re: Calculation of MAT Sales

Thanks this seems to have corrected the formula but the actual number isnt bring in the MAT? it should be \$12682 but its only bring in that month sales only.

• ###### 6. Re: Calculation of MAT Sales

Hi Mellisa,

Your workbook is blank for us , may be this is connecting to your local server there .

May be you can elaborate the same.

Thanks,

Ritesh