saying invalid formula

Options

can someone tell the exact problem in the formula

Tagged:

Answers

  • @Nehal1511 

    Looking at the error it seems that you have not created 'Unit Price %' line item in the REV04 Price Growth Rate Module. 

    Also check the second Lookup that you have applied, try to match it with the second screenshot that you have attached.

    It will then work

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • @Nehal1511 

    Don't copy paste the formula. Try to refer the line items

  • i have created the line items in REVO4 Price Growth Rate module then also it is not working
  • @Nehal1511 

    Its REV04 and not REVO4. Kindly get a clarity whether it's 'Zero' or 'Alphabet O'

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • not working
  • sorry mistakely in reply i wrote o not 0
  • Attach the screenshot of the error, the line item that you have created in the module and the dimensions(blueprint view).

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • IMG_20210923_191253.jpg

    IMG_20210923_191350.jpg

    IMG_20210923_191400.jpg

       

  • Also attached the REV04 module
  • @Nehal1511 

     

    There is a space between 'Unit Price' and '%' in the formula. BUt the same is missing in the module that you have created.

     

    ~Anand

     

    A free advice: It will be a good idea to use Snipping Tool that is provided by windows.

     

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • solved