Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have scenario
I have a data like below
Year Sales
2011 234
2012 456
2013 342
2014 476
2015 435
2016 982
from
2017 2016 sales value+(2016 sales value*1%)
2018 2017 sales value+(2017 sales value*1%)
2019 2018 sales value+(2018 sales value*1%)
This percentage value is dynamic it is coming from my input box Sales growth Rate
And i want to this calculations in my front end not in script(since the variable value will be selected by end user).
So i want to do this in my chart expressions.
Is there any way to this.
Please do the needful
Thanks
Thiru
Try this expression:
=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)
Where Column(1) is your first expression
Try this expression:
=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)
Where Column(1) is your first expression
Hi Sunny
Thanks
It's working
Thiru
Hi Sunny
Is there any other way to do directly with out if and with out column() functions
Now
=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)
I need
= Above(Sum(Sales)) * 1.1)
Thiru
You want the same result, but you want to do without using if and Column() function?
Here is another method you can try:
RangeSum(Sum({<Year = {"$(='<=' & Year(Today()))"}>}Sales),
Above(Sum({<Year = {"$(='>=' & Year(Today()))"}>}Sales), RangeMax(RowNo() - Year(Today()) + Min(TOTAL Year) - 1, 1)) * pow(1.1, RowNo() - Year(Today()) + Min(TOTAL Year) - 1))
Hi Sunny
How to use
this
=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)
in text box objects?
Thiru
What number/numbers do you want to see in the text box?
Hi Sunny
It's not numbers based on this values i need to get that date,As per our old discussion for crash date actual vs target
here using this i need to get that Crashdate and Actual date.
action date on chart based on max value
Regards
Thiru
Hi Sunny
I have created a variable which is =Year(Today)
so wherever you used Year(Today) can you please replace with V_YEAR variable and try it
Please do the needful
Regards
Thiru