Find answers, ask questions, and connect with our
community around the world.

  • DBRW Not Working in TM1Web

    Posted by Will on 9-Feb-21 at 10:46 am

    Hi guys, I have a DBRW that into working properly in TM1Web. I have essentially the following formula:

    DBRW(‘CXMD:Sales and GP’, ‘2020’, ‘Oct’, ‘Actual’, ‘Product X’, ‘Sales $’)*-1

    But it is not displaying in TM1Web.

    Any ideas please?

    John replied 3 years ago 2 Members · 1 Reply
  • 1 Reply
  • John

    Administrator
    10-Feb-21 at 2:05 pm
    2 Diamonds
    14 Gold
    2,170 Experience
    Hiker

    Hi Will. One of the joys of DBRW through TM1 Web is that you cannot use a compound formula. So you can’t combine anything into it or use it in another formula in the same cell. So your DBRW *-1 example would be considered a compound formula. What you can do is put your DBRW in a cell and then in another cell multiply the DBRW cell by -1. This will give you the correct result and not result in a compound formula. There i more information about compound formulae and DBRW in this post from IBM.

Log in to reply.