Problem In Range

[vijayit43]

Hi Expert,             

My Data Format is 

FINYEAR	FROMSLABMT	TOSLABMT	CUSTOMERTARGETID
2014-2015	0	50	CLUB-A
2014-2015	50	300	CLUB-B
2014-2015	300	1100	CLUB-C
2014-2015	1100	2600	CLUB-D
2014-2015	2600	100000	CLUB-E

Header 1

and one column in Quantity when total quantity between 0 to 50 then CLUB-A when 50-300 then CLUB-B as so on how to write script on text Object Please Suggest Attached Referance given Bellow..

[Gysbert_Wassenaar]

If I understand your question correctly then you can use the intervalmatch function to match the quantities with the intervals. You'll have to use the extended syntax to make the match for each FINYEAR value. You can find an example here: Re: IntervalMatch Multiplying Records

[vijayit43]

I cant understand Interval match function please suggest with example

[Gabriel]

Hi,

Read this doc for better understanding of IntervalMatch function.

[vijayit43]

In Interval Match Function used in Script, But My problem not in Script My Problem In Front end where data change according to filter.

[MarcoWedel · Accepted solution]

Hi,

one possible solution could be:

=Only({$<FROMSLABMT={"=FROMSLABMT<=$(vTotalSale)"},TOSLABMT={"=TOSLABMT>=$(vTotalSale)"}>} CUSTOMERTARGETID)

hope this helps

regards

Marco

[vijayit43]

How to add in Pivot Chart AS Like this.

FINYEAR	CUSTACCOUNT	CUSTOMERTARGETID
2014-2015	CUST/000002	CLUB-A
2014-2015	CUST/000007	CLUB-E

[MarcoWedel]

Hi,

this might be difficult with set expressions because those are evaluated only once per table, not per row.

Please close this thread if your initital question regarding text boxes is answered.

thanks

regards

Marco