3 Replies Latest reply on Oct 24, 2018 1:51 PM by Mavis Liu

    parameter with calculated field, multiple data sources

    jon rios

      i have a parameter that drives a chart, each parameter selection has it own calculation field, so i have a CASE statement,

       

      BUT i have 6 formulas that come from another data source.  if i add these 6 formulas from the other data source, i get an error, "all filds must be aggegated if using mutliple data sources"

       

      the original formula is NOT an aggregation, none of the other calculations are aggregations,....  even if i add a SUM() or a ATTR() to these 6 formulas, they still have an error...

       

      can someone give me advice?