Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Bar graph where I have to show historical data for this I was planning to create 2 variables which show past period start date and end date.
I have a date range from which the user can pick a start and end date to see the result. Below is the screenshot of my requirement.
for current trend line chart I am using below mentioned formula
num(Sum({$<[Posting Date]={">=$(=vCYStartDate)<=$(=vCYEndDate)"} >} Revenue),'####.##')
Same formulas I am planning to use for historic trend but This 2 varialbes wont work.
CYStartDate - hard coded - 01/04/2018
CY end date - 31/12/2020
Request you to please help me with the formulas for past period variables.
I am trying with below but isnt working
VPyend date =date(addyears(max([Posting Date]), -1), 'DD/MM/YYYY')
when I try calling this variable in text and object but its not working.
vPYstart date - =date(MakeDate( subfield(vPYEndDate,'/',3),subfield(vCYStartDate,'/',2)),'DD/MM/YYYY')
Request you to please suggest...
Hi Sunny,
I have a Bar graph where I have to show historical data for this I was planning to create 2 variables which show past period start date and end date.
I have a date range from which the user can pick a start and end date to see the result. Below is the screenshot of my requirement.
for current trend line chart I am using below mentioned formula
num(Sum({$<[Posting Date]={">=$(=vCYStartDate)<=$(=vCYEndDate)"} >} Revenue),'####.##')
Same formulas I am planning to use for historic trend but This 2 varialbes wont work.
CYStartDate - hard coded - 01/04/2018
CY end date - 31/12/2020
Request you to please help me with the formulas for past period variables.
I am trying with below but isnt working
VPyend date =date(addyears(max([Posting Date]), -1), 'DD/MM/YYYY')
when I try calling this variable in text and object but its not working.
vPYstart date - =date(MakeDate( subfield(vPYEndDate,'/',3),subfield(vCYStartDate,'/',2)),'DD/MM/YYYY')
Request you to please suggest...
If u want some person need help You can always tag them using @ option. This will notify to user.
For now, I've done for you @sunny_talwar
BTW, What r u trying to achieve here using this expression?
num(Sum({$<[Posting Date]={">=$(=vCYStartDate)<=$(=vCYEndDate)"} >} Revenue),'####.##')
Those variables not working? If so, Can you simplify like this?
num(Sum({$<[Posting Date]={">=$(=Date(AddYears(vCYStartDate,-1)),'Same as Posting Date')<=$(=Date(AddYears(vCYEndDate,-1)),'Same as Posting Date')"} >} Revenue),'####.##')