• ksqd1112
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 1
    Replies

I'm using flow to build a series of wizards for a equipment rental application. 

 

 

One of the screen choice fields I use is for Check-Out fuel level.  I'm using a dropdown list.  The requirement is for the user to enter a value.  The problem I'm encountering is that though I don't choose a default value the screen choice field populates with the first value in the list of choices assigned to the screen.  So for example the equipment is 1/2 full of fuel.  The screen choice field field defaults to full.  The concern is that the user will blow by the entry and check out all the equipment as full which would be costly error.  My only other choice is to use radio buttons which at 1/8 tank plus "Empty" would require 9 buttons, not my first choice as a user interface.  Am I missing something here?  Any ideas?

 

 

 

 

 

 

I'm having a devil of a time getting this formula to work for me.  If anyone can see something obviously wrong I'd appreciate the help.

 

IF (AND( Total_Days_to_Quote__c > 16, Total_Days_to_Quote__c <= 28), 1,

IF(AND (FLOOR( Total_Days_to_Quote__c / 28 ) > 1 , MOD( Total_Days_to_Quote__c ,28) > 16 ) , (FLOOR( Total_Days_to_Quote__c / 28 ) + 1),

IF(AND( MOD( Total_Days_to_Quote__c , 28) < 16 , FLOOR( Total_Days_to_Quote__c / 28 ) > 1) , FLOOR( Total_Days_to_Quote__c / 28 ) , 0)))

 

I’m trying to configure a formula field with a series of nested IF statements which each use an AND function.  The business problem briefly is as follows:  A customer get quoted an entire month after the 16th day of a quote period.  I’m trying to determine how many months to quote using the Mod and Floor functions.  So if the customer has the product after the 17 thru 28 day they are quoted for 1 month.  All monthly calculations are based on 28 days.  If they keep the product until the 17 day after the first month they will be quoted for another month for a total of 2 months.  If the customer keeps the product less than 17 days the monthly quoted rate is 0.  I’m using Total_Days_to_Quote as my number of days to base the quote.  My code will compile.  If the condition for the first IF is met the line executes properly.  If any other conditions exist the second and third IF statements don't execute as I think they should and the formula returns 0. 

 

My formula consists of 3 IF statements and an ending “0”. 

 

The first IF tests for quote days between 17 & 28 in period 0.

 

The second IF tests for subsequent contract periods greater than the first period using the FLOOR function (tests for next lowest integer) and the days greater than 16 using the MOD functions (tests for remainder).  .

 

The second If tests for subsequent contract periods greater than the first period using the FLOOR function and days less than 16 using the MOD functions (tests for remainder) and FLOOR function (tests for next lowest integer).  I can't get this statement to return a value.

 

Finally if none of the IF conditions are met a 0 is returned.  This is the value is being returned except for IF statement 1.

 

Thanks for your help in advance,

 

Ken

 

I'm using flow to build a series of wizards for a equipment rental application. 

 

 

One of the screen choice fields I use is for Check-Out fuel level.  I'm using a dropdown list.  The requirement is for the user to enter a value.  The problem I'm encountering is that though I don't choose a default value the screen choice field populates with the first value in the list of choices assigned to the screen.  So for example the equipment is 1/2 full of fuel.  The screen choice field field defaults to full.  The concern is that the user will blow by the entry and check out all the equipment as full which would be costly error.  My only other choice is to use radio buttons which at 1/8 tank plus "Empty" would require 9 buttons, not my first choice as a user interface.  Am I missing something here?  Any ideas?

 

 

 

 

 

 

I'm having a devil of a time getting this formula to work for me.  If anyone can see something obviously wrong I'd appreciate the help.

 

IF (AND( Total_Days_to_Quote__c > 16, Total_Days_to_Quote__c <= 28), 1,

IF(AND (FLOOR( Total_Days_to_Quote__c / 28 ) > 1 , MOD( Total_Days_to_Quote__c ,28) > 16 ) , (FLOOR( Total_Days_to_Quote__c / 28 ) + 1),

IF(AND( MOD( Total_Days_to_Quote__c , 28) < 16 , FLOOR( Total_Days_to_Quote__c / 28 ) > 1) , FLOOR( Total_Days_to_Quote__c / 28 ) , 0)))

 

I’m trying to configure a formula field with a series of nested IF statements which each use an AND function.  The business problem briefly is as follows:  A customer get quoted an entire month after the 16th day of a quote period.  I’m trying to determine how many months to quote using the Mod and Floor functions.  So if the customer has the product after the 17 thru 28 day they are quoted for 1 month.  All monthly calculations are based on 28 days.  If they keep the product until the 17 day after the first month they will be quoted for another month for a total of 2 months.  If the customer keeps the product less than 17 days the monthly quoted rate is 0.  I’m using Total_Days_to_Quote as my number of days to base the quote.  My code will compile.  If the condition for the first IF is met the line executes properly.  If any other conditions exist the second and third IF statements don't execute as I think they should and the formula returns 0. 

 

My formula consists of 3 IF statements and an ending “0”. 

 

The first IF tests for quote days between 17 & 28 in period 0.

 

The second IF tests for subsequent contract periods greater than the first period using the FLOOR function (tests for next lowest integer) and the days greater than 16 using the MOD functions (tests for remainder).  .

 

The second If tests for subsequent contract periods greater than the first period using the FLOOR function and days less than 16 using the MOD functions (tests for remainder) and FLOOR function (tests for next lowest integer).  I can't get this statement to return a value.

 

Finally if none of the IF conditions are met a 0 is returned.  This is the value is being returned except for IF statement 1.

 

Thanks for your help in advance,

 

Ken