
1. Re: Calculate Only Where Value is not 0
Shinichiro Murakami Sep 1, 2018 2:54 PM (in response to mike.dale)Could you clarify how you calculated 44% and 5 %?
Please write down exact formula.
Thanks,
Shin

2. Re: Calculate Only Where Value is not 0
Shinichiro Murakami Sep 1, 2018 3:02 PM (in response to Shinichiro Murakami)2 of 2 people found this helpful 
3. Re: Calculate Only Where Value is not 0
Shinichiro Murakami Sep 1, 2018 3:17 PM (in response to Shinichiro Murakami)You are confused with field name 'year'.
{max([Year])1 = 2010/12/31
{max(year(Year))} = 2010
In that sense better modify current as well.
Thanks,
Shin

Ratio_SM_10.5.twbx 98.5 KB


4. Re: Calculate Only Where Value is not 0
Shinichiro Murakami Sep 1, 2018 3:26 PM (in response to Shinichiro Murakami)
Ratio_SM_10.5.twbx 104.2 KB


5. Re: Calculate Only Where Value is not 0
mike.dale Sep 1, 2018 3:46 PM (in response to Shinichiro Murakami)Thanks, I think you have nailed it.
So what should the 'YoY Chg' measure calculation be? Because it this is not returning anything. I need this to show the percentage difference in change.

6. Re: Calculate Only Where Value is not 0
mike.dale Sep 1, 2018 3:46 PM (in response to Shinichiro Murakami)Thanks, I think you have nailed it.
So what should the 'YoY Chg' measure calculation be? Because it this is not returning anything. I need this to show the percentage difference in change.

7. Re: Calculate Only Where Value is not 0
Shinichiro Murakami Sep 1, 2018 4:13 PM (in response to mike.dale)Delta of Aggregation of Aggregation is getting complicated.
I don't know ho you want to show it.
Here is a example, but the table cacl setting needs to be modified if you need different format.
If these helped, please mark my answer as correct helpful to close the thread not from inbox but from original post.
Thanks,
Shin

Ratio_SM_10.5_v2.twbx 105.0 KB


8. Re: Calculate Only Where Value is not 0
Ankit Bansal Sep 1, 2018 10:55 PM (in response to mike.dale)Mike,
This will work for you:
if (sum([OnSite]))>0
then SUM(if [OnSite]>0 then [Digital] end)/sum([OnSite])
else 0
END
Thanks,
Ankit Bansal

9. Re: Calculate Only Where Value is not 0
mike.dale Sep 2, 2018 1:52 PM (in response to Shinichiro Murakami)Hi Shin,
I just want to show the percentage difference on each bar on the year on year chart.
I tried to look for Mark answer as correct but I cant see such option anywhere
Thanks.

10. Re: Calculate Only Where Value is not 0
Shinichiro Murakami Sep 2, 2018 2:33 PM (in response to mike.dale)As I said,
please mark my answer as correct helpful to close the thread not from inbox but from original post.
Here is one idea.
Thanks,
Shin

Ratio_SM_10.5_v3.twbx 110.6 KB
