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

 

Create two list,

Technorati Tags: SharePoint,SPD,Designer,customizing Views,OOTB,Exchange Rate

Requirement:

I have 1 list with key | Exchange Rate  two columns

Technorati Tags: SharePoint,SPD,Designer,customizing Views,OOTB,Exchange Rate

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

multiplied value

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

2)

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

4)