i have a bar chart which shows the amount spend/video views ratio for the given days. i want multiply some days with 3 and and some days with 4.
[Report Starts] is in date format (YYYY-MM-DD)
i figured it out when i simplified the expression;
IF ([Reporting Starts] <= date#('2016-02-26','YYYY-MM-DD'), Avg([cost per view1])*3, Avg([cost per view1])*4.4)
thanks for your help