Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have below Data.
Sales Level 2 | Customer Count | Bookings | % Bookings |
6958 | 222457000.8 | 100% | |
CANADA | 631 | 20932019.92 | 9.41% |
LATIN AMERICA | 741 | 29788670.25 | 13.39% |
US COMMERCIAL | 4098 | 58816212.46 | 26.44% |
US ENTERPRISE | 549 | 51737137 | 23.26% |
US OTHER | 3 | 5475872.92 | 2.46% |
US PS MARKET SEGMENT | 1402 | 55707088.24 | 25.04% |
I wanted to pick up the values from Bookings column.But Booking column is coming from calculated expression.
Is this possible to get the values from calculated columns Data from Char() function or It will work only for Script Level data.
PFB Script
LOAD [End Customer Global Ultimate Name],
Country,
[End Customer HQ Top],
If([Sales Level 2]='EMEAR-EMERGING','EMEAR-REGION' ,
If(Match([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI') OR MATCH([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI','EMEA OTHER','EMEAR-UNALLOCATED'),'EUROPE',[Sales Level 1])) as [Sales Level 1],
[Sales Level 2],
[Sales Level 3],
[Sales Level 4],
[Sales Level 5],
[Partner Name],
[Fiscal Period ID] as Fiscalid,
[Net Bookings],
CATEGORY
FROM
Regards,
Karim Khan
I don't understand what you are trying to achieve and how you want chr() to work here.
From where do you want to pick up the values?
If you want to use results from expressions in another expression, you can reference the expression column using
Column() function or stating the expression label "Bookings". Like
="Bookings" * 1.19
Not sure if this is what you are after.
Could you post a small sample QVW?