I am creating a budget and have amounts incoming at various frequencies. I want to create a field that calculates the monthly amount based on a formula. This is the formula I have got but I get an Invalid Formula error message:
Thank you! I now have it like this but it's still giving me an the error "Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.":
IF(
{Frequency} = "Daily",{Amount} * 30,
IF(
{Frequency} = "Weekly",{Amount} * 4.33,
IF(
{Frequency} = "Bi-weekly",{Amount} * 2.167,
IF(
{Frequency} = "Monthly",{Amount},
IF(
{Frequency} = "Quarterly",{Amount} / 3,
IF(
{Frequency} = "Twice-Annually",{Amount} / 6,
IF(
{Frequency} = "Annually",{Amount} / 12,
)
)
)
)
)
)
Looks like you deleted the last "0" at the end of your formula; it should be "/12, 0"?
There's no commenting system for formulas I'm afraid. Once you remove the // it'll work fine:
Thank you! I now have it like this but it's still giving me an the error "Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.":
Thank you! I now have it like this but it's still giving me an the error "Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.":
IF(
{Frequency} = "Daily",{Amount} * 30,
IF(
{Frequency} = "Weekly",{Amount} * 4.33,
IF(
{Frequency} = "Bi-weekly",{Amount} * 2.167,
IF(
{Frequency} = "Monthly",{Amount},
IF(
{Frequency} = "Quarterly",{Amount} / 3,
IF(
{Frequency} = "Twice-Annually",{Amount} / 6,
IF(
{Frequency} = "Annually",{Amount} / 12,
)
)
)
)
)
)
Looks like you deleted the last "0" at the end of your formula; it should be "/12, 0"?
