Inserting Symbol Based on Value

[#1]

Hi Firends,

Need Help in Syntax for the below Requirement:

ID	RD1				RD2
1	PT	Def	ID	Amount	PT1	Def1	ID	Amount1
1	X	Finance	1	18000	X	Operation	3	9000
5	y	Finance	1	250000	y	Operation	3	3000
6	Z	Finance	5	9000	Z	Operation	4	120000
7	w	Finance	6	5000	w	Operation	4	1000
9	t	Finance	7	2000	t	Operation	9	3000
The Output for RD1 is:		The output for RD2 is:
Id	Amount	Id	Amount1
1	$250,000	3	$9,000

I need to put $ symbol in the highest Amount in lowest id.(here we need to write the expression or script based on the 'id' Filed only.Also Have attached the QVW file. Any help would be great.

Thanks in Advance.

Regards,

Pooja

[sunny_talwar · Accepted solution]

Check it out

Expressions

1)

If(id =Min(TOTAL id) and  Amount = Max(TOTAL <id> Amount), '$') & Amount

or may be a better one would be this:

If(id = Min(TOTAL {<pt = {'*'}>}id) and  Amount = Max(TOTAL <id> Amount), '$') & Amount

2)

If(id = Min(TOTAL {<pt1 = {'*'}>}id) and  Amount1 = Max(TOTAL <id> Amount1), '$') & Amount1

[#3]

Hi Sunny,

Thank you so much. It's working as expected.

Regards,

Pooja