Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
FinancePerson
Contributor
Contributor

How do i convert my long string text dollars into positive money numbers? (The negative conversion works.)

Good morning All,

      I am working on a file from another company. The money represented comes over in a text format 16 characters long.

Ex. 0000000000013054

I can get the negative numbers to load with the following script:

if(left(trim([@43:59]),1)='-',num#(right([@43:59],14))/-100,num#(trim([@43:59]))/100) as pay_amount

but the positive numbers wont pull through. 

Desired result from ex above: $130.54 

Labels (2)
1 Solution

Accepted Solutions
Henric_Cronström

Try

Money(Evaluate([@43:59])) as pay_amount

View solution in original post

1 Reply
Henric_Cronström

Try

Money(Evaluate([@43:59])) as pay_amount