cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Kermit,

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

-Abhilash