Within a table, I need to divide the number of off-types by 1,000 to give me % of off-types.
I’ve been trying formulas like =SUM(INDEX(Test.V___off_Types,ROW()))/1000 but have had no success.
Thanks in advance
Hi Doug,
There are a couple of settings I assumed in testing this: the fields are both Number fields, and the percentage number field has been configured to allow for 3 decimal places.
I'm using Forms 10.2 for the testing.
I used the following formula in the percentage field:
=DIV(INDEX(Test.off_Types,ROW()),1000)
This worked successfully:
Cheers,
Mike
Drat, Mike beat me to the punch.
The two important things are the Number field type and the allowed number of decimal places; the first can cause unexpected behavior due to OpenFormula conversion rules, and the second can cause the display to appear as though the calculation does not permit less-than-whole values.
The DIV() function is an alias for the '/' infix operator, so either should work.
Cheers
Hello good sir.
What do I do if your perfect example worked, but I want to * 10 it?
Mine looks like:
=DIV(INDEX(commission_Report_RC_Table.commission_Report_RC_Table_Markup,ROW()),30)
And finally after googling myself to death it works thanks to you.
I need my result to be multiplied by 10 every time!
Thanks in advance.