I am building a Flow that creates a new Opportunity if an Opportunity is Closed Won and meets a certain criteria based on a custom Picklist field called Coupon Type Used(Coupon_Type__c). The Picklist values for the Coupon_Type__c field are NULL,"No","25", or "50".
I am trying to create a flow formula that calculates the amount on the new Opportunity that needs to be created. If the Coupon_Type__c is 25 or 50, the amount for the new Opportunity record needs to be (Amount/(1-VALUE(Coupon_Type__c)*0.01))
I thought by putting in the VALUE function, it would convert the text in the Coupon_Type__c to a number. However I am getting an issue that is preventing me from saving the flow.
Is there anyone who knows what I am doing wrong?
Thank you so much!!