CASE results in 'error querying your data model'


1 comment

  • Avatar
    Gowtham Senthilkumar (Edited )


    Save ((Sum([Total amount]), [account_type]) - [Income from Sale of Property] - [Other Expenses - Depreciation] - [Interest]) as a Starred Formula and then use that in IF statement or a Case When statement to see if that's working. 

    Also make sure [Income from Sale of Property], [Other Expenses - Depreciation] and [Interest] are all aggregations (like SUM) and not ALL ITEMS. 

    Comment actions Permalink

Please sign in to leave a comment.