Unable to Change the Summary of Line Item from Sum to Formula: Time, Sum
I'm getting an error when changing a line item's summary from "Sum to Formula: Time, Sum":
"Invalid combination for line item 'Sales' of summary method 'Formula' with formula using LOOKUP and/or SUM (or other summary function)"
The formula of the line item does indeed have a Sum function, and I'm getting it from another module which has a "Formula: Time, Sum" summary. I would like to be able to get the same amount as that module summed by industry for example:
But because they have the different summary, I'm not able to get the same results.
Thanks in advance for any input you can give.