Monday, October 14, 2013

Showing different values in SharePoint all item views in only in view based on configuration list [currency, Exchange date] defined

 

Create two list,

Requirement:

I have 1 list with key | Exchange Rate  two columns

List 1:

key

Exchange Rate

A

0.5

B

2

C

2

D

3

>>>>>>>>>

List 2: another list Amount List Key Amount

key

Amount

A 1000

1000

A 2000

2000

B 3000

3000

whenever users open any particular view (example test.apsx) of second list ( customized in SPD)

I have to get below results depending upon the exchange rate defined in configuration list 1

I,e exchange rate * Amount

key

Amount

A

500

A

1000

B

6000

 

Report has been implemented in my test site, follow the process to do it. Make you’re your configuration list currency will be look up with

clip_image001

multiplied value

1) Select your column to multiple in any newly created new, select formula on the top

2)

clip_image001[8]

3) Multiply the value with the current node as per the snap shot

4)

clip_image003

image

No comments:

Post a Comment