Skip to Content
0

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

Nov 01, 2016 at 08:29 PM

26

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Mar 13, 2017 at 07:32 AM
0

Hi Kermit,

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded