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

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

Thursday, October 10, 2013

What I miss about you [Katie Melua], version 2 by me

 

Its a try !! don’t know how you all feel another version of this song, suggestion and corrections are always welcome.

Missing the talk every night at 8.52

Forgetting myself in our talks as you do

The sharing of feelings that no one else knew

That’s what I miss about you

 

The every smile of yours made me mad

Your starring eyes, melting in my smile told everything

How every day you used to care me

That’s what I miss about you

 

Your presence in my boring life, exciting me

Driving in your dream every day, that was free

Gearing up the imagination, laughing for nothing free zed me

You made me feel you’re mine, like fruits for tree

 

The way you tried to separate the parasite

Your habit of stubborn ever never stopped

The way you said, I am not your bite

Pushing me like thorn of life which you chewed

That's what I don't miss about you

 

I bet you're lying wearing the hating mask

Spoiling the life with your own rules

Expecting me to forget our entire task

Knowing we are in a two different poles

 

The way I doubted believing others was wrong

This is one way of loving for few

The moment you are here, hearts beat prolong

Your skill of putting me down in a flash of flew

That’s what I don't miss about you