Good day!
I am trying to add a column with a count of a TOTAL SUM of different values in Transpose table. (simply: Rename Fee
+
(amFee
-Platinum amFee
)+
Platinum amFee
+
VIP No IVA
+
Collector price no IVA
) etc
My columns that needs to be Summed are in format: 123=SUM() Aggregation SUM and one column is a fixed number in format 123=Expenses (No Aggregation). this later column is causing me a lot of trouble haha, as in my Total SUM count at the end it shows up as a huge number (probably a sum of smht) instead of the fixed one.
This is my 123=Expenses (No Aggregation) CASE
CASE
WHEN nmOrganizer
= 'Hub Music Factory S.r.l.' AND nmPerformance
= 'The Offspring' THEN -2294.62
WHEN nmOrganizer
= 'Hub Music Factory S.r.l.' AND nmPerformance
= 'Social Distortion' THEN -964.54
ELSE 0 END
Here is the
123=SUM() Aggregation example
amRenameFee
/1.22
Is this happening because it's not possible to sum Aggregation SUM with (No Aggregation) fixed number? or it's smth else?
hope it makes sense, if NOT I can give more details.
Thank you in advance!