topic Variable creation for past period in App Development

Variable creation for past period

deepika_gohil — Sat, 16 Nov 2024 05:47:59 GMT

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...

Variable creation for past period

deepika_gohil — Sat, 18 May 2019 04:16:31 GMT

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...

Re: Variable creation for past period

Anil_Babu_Samineni — Sun, 19 May 2019 15:14:15 GMT

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),'####.##')