problem with sum

[Anonymous]

hi,

i build in the script feild that show each day number that i use for calculted.

if(match(WeekDay([date]),'sat'),num(0.15),
if(match(WeekDay([date]),'fri'),num(0.60),
if(match(WeekDay([date]),'sun','mon','tue','wed','thu'),num(1)))) as [action day]

when i want to use this feild - "action day" for  sum, i'm geting not the right answer.

mybe this feild is not numeric ?

thanks'

yarin.

,

[sivarajs]

Try this

if(wildmatch(WeekDay([date]),'sat'),num(0.15),
if(wildmatch(WeekDay([date]),'fri'),num(0.60),
if(wildmatch(WeekDay([date]),'sun','mon','tue','wed','thu'),num(1)))) as [action day]

[Anonymous]

hi thanks',

but it's still doesn't work.

what can be the problem ?

[Gysbert_Wassenaar]

Weekday returns an integer, not a string. You can use the pick function:

pick(weekday(date)+1,1,1,1,1,0.6,0.15,1) as [action day]

[Anonymous]

hi,

it's desn't workink.

see attuched.