0 Replies Latest reply: Oct 31, 2018 10:39 AM by Martin Hamilton RSS

    Compare a passed value and a calculation

    Martin Hamilton

      Hi - am looking at providing an indicator in the dashboard based on comparing a passed value and a calculated one.


      My data looks like this:


      Account file

      Subscription file - joined using an account number on both tables

      I have attached sample data in a single excel with multiple sheets.


      what I wish to do is compare the Total_Active_Subs on the Account Table with an expression which I have created which calculates active subscriptions.

      if the value mismatches then it will show a value 'Split Account' - if it matches then it will show 'Fully Managed'.


      Alternatively is it possible to do or better to this within the load script to create a resident table? is it possible to do within a chart?


      what is the best way to do it?