set analysis expression based on field value

[ilanbaruch]

hi all,

i have a week day table with values which i want to calculate against WeekDay(now())

any ideas or another way to figure it?

advanced thanks.

week day	value
Monday	50
Tuesday	150
Wednesday	200
Thursday	130
Friday	400
Saturday	330

[sinanozdemir]

Hi,

You can employ Date() function and here is an example by using your data:

Hope this helps.