Skip to Content
0
Former Member
Nov 01, 2016 at 08:29 PM

Getting the message 'A Boolean is required here' on CR XI

95 Views Last edit Mar 11, 2017 at 09:44 AM 2 rev

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...