-
CASE When order
Hi team, I need to figure out how to order my Hub Music Factory WHEN cases. The OUTPUT that I want to get is that when I select ONLY nmOrganizer - Hub Music Factory, the result comes out as the total sum of all Hub Music Factory values in green *where there is also specified nmPerformance plus /12500. BUT when I select…
-
Can I sum 2columns one being Aggregation SUM and other (No Aggregation) fixed number?
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…
-
How to show a grouped Column with a CASE logic
Hi, could smb help me on the issue below please: the below CASE model for 'Royalty add on' is splitting my ORGANIZER 'Live Nation Italia' into 3 columns creating splits also for Autorization and Shipping exp. The idea is to have a sum of all these values and see only 1 column for Live Nation Italia. I know for sure that…