10 Replies Latest reply on Jan 12, 2018 5:04 AM by Jyothisree Rayagiri

How to get combine float and Sting (k)

rakesh jadhav Jan 11, 2018 11:50 PM

Hi Team,

I do have calculation field in which i have to do count and for rest of i have to show values in THOUSAND in k.

Means if u select Invoice Count in parameters selection then it should give count of Invoice Count,

And for rest means for Invoice Amount , Lots, Trade it should give Sum of amount in thousand in k.

The above screen shot will get idea about how I used to convert it into thousands,but issue it is applying to All calculation ,

I need ONLY for Invoice Amount , Lots, Trade it should give Sum of amount in thousand in k.

if I click on Invoice Amount I should give values in Thousand with k..means currently its giving 364,978 I need 365 k but Invoice Count value should not be in thousand (K)

Please help me out of this.

Thanks in advanced.

Valus-In-Thousand.twbx 2.2 MB

1. Re: How to get combine float and Sting (k)

Sravan Yadav Jan 12, 2018 12:07 AM (in response to rakesh jadhav)
Hi Rakesh,

PFA for the above requirement...

Hope dis helps you...

Sravan.

Valus-In-Thousand.twbx 2.2 MB
Like Show 1 Likes(1)

Actions
2. Re: How to get combine float and Sting (k)

Tushar More Jan 12, 2018 12:13 AM (in response to rakesh jadhav)

Hi Rakesh,

Create a calculated field.
Replace your existing calculation with this.

Let me know if this helps.

~Tushar
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
3. Re: How to get combine float and Sting (k)

rakesh jadhav Jan 12, 2018 1:49 AM (in response to Sravan Yadav)

Hi Sravan,
very very much thanks for yours reply its work for me but when i am trying to drag the Thousand(k) dimensions in Text its showing me like below screen shot.value below the k .
How to make it in one line.

Its making difficult to make in one line.
Can you help me out of this.

Thanks in advanced .
Like Show 0 Likes(0)

Actions
4. Re: How to get combine float and Sting (k)

Sravan Yadav Jan 12, 2018 2:16 AM (in response to rakesh jadhav)

Hi Rakesh,

Just click on Label on Marks Card and Edit Text and place the Thousand(K) dimension just BESIDE to your measure...

See the Screenshot for reference...

Sravan.
2 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
5. Re: How to get combine float and Sting (k)

Sravan Yadav Jan 12, 2018 2:26 AM (in response to rakesh jadhav)

Hey Rakesh,

Can you click on "Correct Answer" whichever thread is Correct so that others may use the same solution if anyone have stuck on the same issue...

Sravan.
Like Show 0 Likes(0)

Actions
6. Re: How to get combine float and Sting (k)

rakesh jadhav Jan 12, 2018 2:38 AM (in response to Sravan Yadav)

Hi Sravan,
Thanks Thanks its really help me out,
Please can you help me how use TWO decimals points in that THOUSANDS (K).
so that my final ans will be 243.15k some think like that.

Thanks in advanced.
Like Show 0 Likes(0)

Actions
7. Re: How to get combine float and Sting (k)

Sravan Yadav Jan 12, 2018 2:49 AM (in response to rakesh jadhav)

Hey,

Please find the below screenshots for the above question..

You will get the same two digit decimal if you select Invoice Count aswell... as seen in the BELOW screenshot

Sravan
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
8. Re: How to get combine float and Sting (k)

rakesh jadhav Jan 12, 2018 2:53 AM (in response to Sravan Yadav)

Hi Sravan,
Very very much thanks.
Its really help me out.
Thanks for yours important time,and valuable answer.

Thanks ones again.
Like Show 0 Likes(0)

Actions
9. Re: How to get combine float and Sting (k)

rakesh jadhav Jan 12, 2018 2:58 AM (in response to Sravan Yadav)

Hi Sravan,
but if i used this direct method i will get count also in TWO decimals .
but as practically count cant be in decimals.
So how to handle this issue.
Like Show 0 Likes(0)

Actions
10. Re: How to get combine float and Sting (k)

Jyothisree Rayagiri Jan 12, 2018 5:04 AM (in response to rakesh jadhav)
Hi Rakesh

You can round your sums for the 3 fields - wrap your sum([measure]) to round( sum([measure]),2) and then select number(standard) in the format option.

Attached twbx

//Jyothi

Valus-In-Thousand.twbx 2.2 MB
Like Show 1 Likes(1)

Actions