I have data with column Fiscal Year; Fiscal Week; Fiscal Month; Transaction Date; Order Amount - C$
I used below mentioned syntax to calculate "Day of the Week"
_day_of_week ([Transaction Date],1) ( i got the results 1 for Monday; 2 for Tuesday ........ 7 for Sunday).
Then i used below mentioned syntax to get only Monday's in the new column.
If ([Day]='1') then ('Monday') else (' ') ( Here also i got the results)
Now, I want Amount for only Mondays:
Order amount Only Mon Only Mon amount
$100 Monday $100
$30 Monday $30
I tried using the below mentioned syntax to get above mentioned results, But not successful:( (Getting weird reults)
then ([Order Amount - C$])
It would great if anyone can help on this request. Please do let me know if you need any further clarification.