Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 13, 2017 at 07:32 AM

    Hi Kermit,

    What part of the report is this formula being used? Is this an individual formula field created from the field explorer?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded