Salesforce Formula -- 2
Budget: $30 – $250 USD
Current Formula:
IF(
(Field 1 * VALUE(Field 2)) / Field 3 > Field 4,
Field 4,
ROUND((Field 1 * VALUE(Field 2)) / Field 3, 2)
)
So the current formula does calculation and if final result exceeds Field 4. If true, it directly returns the value of Field 4. Otherwise, it returns the actual result of the calculation. The final result return is BLANK for some reason Field 4 is causing an issue the Field 4 is in text format and this formula field format is currency.
ALL OTHERS HAVE BEEN TESTED SO WHEN I SWITCH FIELD 4 with a random number it works when I put the field in who is text(formula) field it gives a blank result.
IF(
(Field 1 * VALUE(Field 2)) / Field 3 > Field 4,
Field 4,
ROUND((Field 1 * VALUE(Field 2)) / Field 3, 2)
)
So the current formula does calculation and if final result exceeds Field 4. If true, it directly returns the value of Field 4. Otherwise, it returns the actual result of the calculation. The final result return is BLANK for some reason Field 4 is causing an issue the Field 4 is in text format and this formula field format is currency.
ALL OTHERS HAVE BEEN TESTED SO WHEN I SWITCH FIELD 4 with a random number it works when I put the field in who is text(formula) field it gives a blank result.