0

Calculate difference from two table on presentation

I have below two table on presentation and I want to calculate difference between Grand Total.

Please See below screen shot:

3 replies

null
    • "making the sophisticated simple"
    • AviPerez
    • 4 yrs ago
    • Reported - view

    You should solve this with a third query. You can easily build a function using Formulate that is the underling difference between the 2 measures in both grids. Then simply show it on the screen as your third grid.

      • Sophie_durrant
      • 4 yrs ago
      • Reported - view

      Avi Perez I am also looking to calculate differences between two grids, but each grid is from a different model- it is a reconciliation from general ledger figures in one grid and sub ledger in the other. Is this possible?

    • "making the sophisticated simple"
    • AviPerez
    • 4 yrs ago
    • Reported - view

    No, not at the moment - unless you built a third model that blends the other 2 somehow. 

    We are busy developing a sophisticated response to this general problem - but it's only due in the next major release of the product. 

Login to reply

Content aside

  • Status Answered
  • 4 yrs agoLast active
  • 3Replies
  • 32Views
  • 5 Following