on 11-01-2016 8:29 PM
The user would enter a parameter number between 1-12 (Representing the month) formula would then calculate. Example:
if {?Enter Month} = '1' then {V_INVENTORY_MSTR.QTY_USAGE_MO_12}+{V_INVENTORY_MSTR.QTY_USAGE_MO_11}+
{V_INVENTORY_MSTR.QTY_USAGE_MO_10}+{V_INVENTORY_MSTR.QTY_USAGE_MO_09}+{V_INVENTORY_MSTR.QTY_USAGE_MO_08}+
{V_INVENTORY_MSTR.QTY_USAGE_MO_07} else
if {?Enter Month} = '2' then {V_INVENTORY_MSTR.QTY_USAGE_MO_01}+{V_INVENTORY_MSTR.QTY_USAGE_MO_12}+{V_INVENTORY_MSTR.QTY_USAGE_MO_11}+
{V_INVENTORY_MSTR.QTY_USAGE_MO_10}+{V_INVENTORY_MSTR.QTY_USAGE_MO_09}+{V_INVENTORY_MSTR.QTY_USAGE_MO_08} else and so on...
Hi Kermit,
What part of the report is this formula being used? Is this an individual formula field created from the field explorer?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.