2 Replies Latest reply on May 23, 2017 11:58 AM by SANDIP SHARMA


    Alex Martino

      IIF([Category]=[Category Parameter],1,0) END


      This tells me that parameter doesn't exist and that there is an error.


      What is wrong?


      Category is just sales category and category paremeter takes that category and places into parameter.

        • 1. Re: parameter
          Jaswanth Moolam

          Hi Alex Martino


          Can you post a screenshot?  Remove "End"


          Also, Flip your calculation IIF([category param] = [category],1,0).



          • 2. Re: parameter
            SANDIP SHARMA

            Hi Alex,


            IIF condition Requires three arguments only IIF(Logical condition,then ,else) NOte: IIF formula is not required any END condition where as your IF condition requires the same.


            then = (What you want to perform for your logical condition)

            Else= Else Condition in case your logical condition is not matching.


            so your formula will be


            IIF([Category]=[Category Parameter],1,0)


            As far as [Category Parameter] existence concern please look into Parameter Section whether that Parameter is exiting there on not if not then recreate the same.