Forum Discussion
Solved
SUMMARIZE error The expression refers to multiple columns... cannot be converted to a scalar value
In general I am struggling with summarizing data in Report View. I've looked for example at https://msdn.microsoft.com/en-us/library/gg492171.aspx But find with this measure: AcctTotal3 = SUMMA...
You seem to have 2 commas, I have highlighted and underlined that part.
calculate(sum(ChargeActivity[Invoice Price])), , "CostpRow", calculate(sum(MTpAcct[Cost/Row])))
Just change that to one comma :)... The error is basically saying that yo have specified one extra arguement or one less, because of the redundant comma.
You seem to have 2 commas, I have highlighted and underlined that part.
calculate(sum(ChargeActivity[Invoice Price])), , "CostpRow", calculate(sum(MTpAcct[Cost/Row])))
Just change that to one comma :)... The error is basically saying that yo have specified one extra arguement or one less, because of the redundant comma.
embarrassing!.. I'll be back I'm sure. many thanks