Limit Braker
New Member
 Joined
 Jun 17, 2020
 Messages
 10
 Office Version

 365
 2019
 Platform

 Windows
Hi guys,
I want to get an average depending of the "year"(column) by dividing a certain amount of days by the sales.
heres moreorless the funciton i came up with but it keep saying its wrong, am i filtering the wrong way?
=IF(FACTSALES[Año]=2019,[Sum of Value]/365,IF(FACTSALES[Año]=2018,[Sum of Value]/365,IF(FACTSALES[Año]=2017,[Sum of Value]/245,0)
Any suggestions on how to do it better?
Error message:
This formula is invalid or incomplete: 'The expression is not valid or appears to be incomplete. Please review and correct the expression.
The end of the input was reached.
Please, thanks
I want to get an average depending of the "year"(column) by dividing a certain amount of days by the sales.
heres moreorless the funciton i came up with but it keep saying its wrong, am i filtering the wrong way?
=IF(FACTSALES[Año]=2019,[Sum of Value]/365,IF(FACTSALES[Año]=2018,[Sum of Value]/365,IF(FACTSALES[Año]=2017,[Sum of Value]/245,0)
Any suggestions on how to do it better?
Error message:
This formula is invalid or incomplete: 'The expression is not valid or appears to be incomplete. Please review and correct the expression.
The end of the input was reached.
Please, thanks