Hi All, I want the current value of the valueloop function when a condition doesnt match. Here is my scenario:
I am trying to colour the graph(in line chart) based on current month value. If the months are greater than current month, i want to show a in grey. Further, I have some missing months in my data. Here is an example of my data:
Acnt Month Sales
A1 Jan 23
A1 Feb 20
A1 Jul 30
A1 Nov 50
I have a requirement to plot missing months with sales values value as 0. I have already achieved this by using Value loop function -
sum(if(ValueLoop(1,12)=[Month No], Sales, 0))
However, While I am trying to colour the graph(Expression>Background Colour), I am having issue. I think If I can get the current value of the value loop function which dont match with the Month Number, I can colour the graph per my need
Please advise.
Thanks
Samy
