Forum Discussion
Syntax for 'ROUNDDOWN' is incorrect when putting it into if function
Thank you both for the help. Now I found where the problem is. It is because of the reginal setting on my computer. Now I changed it to english (united states). Now the syntax error is not showing anymore. 😀
Hi leisay ,
Use the formula
ttire per pal =
IF (
Masterdata[Tireoo_mm] > 750,
DIVIDE (
1250,
ROUNDDOWN (
Masterdata[DeflatedTire Width(494)],
0
)
) * 2,
DIVIDE (
1250,
ROUNDDOWN (
Masterdata[DeflatedTire Width(494)],
0
)
) * 4
)
Regards,
Harsh Nathani
Dear Anonymous ,
Thanks for the quick reply. Actually I want to round down the results of 1250 divided by MasterData[Deflated Tire Width], then multiply it by 2 or 4, depending on the result from the if condition.
I tested in steps:
First I only use ROUNDDOWN(1250/MasterData[Deflated Tire Width(494)],0), it works out fine.
Then I added the if function, then it is shows the syntax incorrect error.
I just start to use powerBI. This formel seems quite simple and works in excel. But in PowerBI I keep getting this syntax error. This is a bit frastrating.
Try saving, closing and then re-opening the file, I recreated the same formula in my file and it showed no errors.
Thank you both for the help. Now I found where the problem is. It is because of the reginal setting on my computer. Now I changed it to english (united states). Now the syntax error is not showing anymore. 😀
