Newbie Questions

Re: Formula Help

warrtalon — Thu, 28 May 2009 17:04:26 GMT

Mine works as long as there are spaces for the divisors, but I do get the same outcome with Samir's formula.

Re: Formula Help

mbrady1973 — Thu, 28 May 2009 17:01:31 GMT

Thanks to all!! Worked Great!

Re: Formula Help

Samir Farid — Thu, 28 May 2009 16:33:10 GMT

First, I think that you might get errors when using warrtalon's formula as there are no spaces between the operations and the fields. Here is the same formula but with spaces:

(((@Ton_Estimate * @SellPrice_ton) - (@Ton_Estimate * @dsiposal_cost) + @Haul_Marg_doll) / (@Ton_Estimate * @dsiposal_cost)) + ((@Fully_Loaded / 60) * @Minutes)

Second, I think you can simplify your formula by changing it to the following:

1. @SellPrice_ton - @dsiposal_cost + (@Haul_Marg_doll / @Ton_Estimate)

Divided by
2. @dsiposal_cost

Plus
3. (@Fully_Loaded / 60) * @Minutes

This is purly a mathemathics change and doesn't affect the outcome.

Your formula in InfoPath would then be:

((@SellPrice_ton - @dsiposal_cost + (@Haul_Marg_doll / @Ton_Estimate)) / @dsiposal_cost) + ((@Fully_Loaded / 60) * @Minutes)

I have attached an InfoPath form with both formulas so that you can test both outcomes.

Hope it helps.

Re: Formula Help

warrtalon — Thu, 28 May 2009 15:19:40 GMT

(((@Ton_Estimate*@SellPrice_ton)-(@Ton_Estimate*@dsiposal_cost)+@Haul_Marg_doll)/(@Ton_Estimate*@disposal_cost))+((@Fully_Loaded/60)*@Minutes)

Formula Help

mbrady1973 — Thu, 28 May 2009 15:10:48 GMT

Good Morning,

I am having trouble making the following formula work.... I need it to calculate in the following order. Not too sure how to format this to make it happen. Thanks in advance.

1. (@Ton_Estimate * @SellPrice_ton) - (@Ton_Estimate * @dsiposal_cost) + @Haul_Marg_doll

Divided by

2. @Ton_Estimate * @dsiposal_cost

plus

3. (@Fully_Loaded div 60) * @Minutes