Skip to main content
Jory Dean (Salesforce) ha fatto una domanda in #Ask An Expert
I am currently building a flow that I intend to use as a nav bar application for my team to help new team members calculate deal gross margins and markups without using a legacy excel calculator. 

 

The problem I am finding is within my formulas: 

 

For example -- 

 

On one screen a sales person would enter the hourly rate and the markup percentages they have contractually agreed on with a client. So let's just say for example it would be 

 

Hourly Rate: 55.00 

 

Percentage: 25% 

 

In order to calculate this properly it would have to be Hourly Rate * 1.Percentage (1.25) which would equal 68.75 which would appear on the calculation screen (since I cannot figure out how to get these to calculate in real time on one screen). 

 

However, in Flow - I cannot get my formula to take the percentage and add the (1.) to it. For other similar calculations I would need to add a decimal in front of the percentage, which I cannot figure out either. 

 

That calc would ideally look like this 

 

Fee based: 100,000

 

Percentage: 20% 

 

Fee based * (.)Percentage = 20,000 , however, I can only make the formula do feebased*percentage 

 

Any suggestions? 
3 risposte
  1. 2 ott 2018, 14:07
    Assuming that Hourly Rate and Percentage  are both screen input fields you could do something like this in your formula resource:

     

    ({!Hourly_Percentage}/100 + 1) * {!Hourly_Rate}

     

    Assuming that Hourly Rate and Percentage are both screen input fields you could do something like this in your formula resource: ({!Hourly_Percentage}/100 + 1) * {!Hourly_Rate} Similarly for Fee Based

     

    Similarly for Fee Based and Percentage create a formula like so:

     

    ({!Fee_Percentage}/100) * {!Fee_Based}

     

    Configuration screen for formula element in Flow showing the calculation for the fee based.
0/9000