Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Looking to see if there is a way to not display all months when a field is zero or null? I've got a budget to actual line chart. I don't want to show values for months that haven't happened yet. Our data is currently minimal, and will be updated via an excel upload. I've tried a few IF statements to no avail. Picture is below (yes, the values are negative on purpose).
Thanks in advance
It is not what I said...
Assuming you "basic" Budget expression is
sum(Churn_Budget_Amount)
and your Reporting expression is
Sum(MRR)
THEN your budget expression should be
if(Sum(MRR)=0, 0, sum(Churn_Budget_Amount))
and Reporting:just
Sum(MRR)
And, don't forget to un-check that box.
Your "Budget expression" should be like this:
If(<Reported Expression> =0, 0, <Budget Expression>)
And in the chart properties, "Add-ons", "Data handling" - uncheck "Show zero values"
Michael,
I have that done, and it doesn't appear to be working.
if(sum(Churn_Budget_Amount)=0,0,sum(Churn_Budget_Amount))
if(Sum(MRR)=0,0,Sum(MRR))
It is not what I said...
Assuming you "basic" Budget expression is
sum(Churn_Budget_Amount)
and your Reporting expression is
Sum(MRR)
THEN your budget expression should be
if(Sum(MRR)=0, 0, sum(Churn_Budget_Amount))
and Reporting:just
Sum(MRR)
And, don't forget to un-check that box.
Ah. That seems to do it.
Thanks.
Michael,
This solution only shows the chart up to the current month. I have going through the same problem. What if I want to show complete Budget line and partial Reported line? Is this a possibility?
Thank you,
Sohail