Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA.
Below is the requirement.
When data for Jan,Feb ,Mar is present then make Jan+Feb+Mar for indicator value and show data for Q1 on march.
Similirly for Q2 on jun for Apr+May+jun
Q3 on sept for jul+aug+sept
And Q4 on dec for oct+Nov+Dec
If any month in any of quarter is not present then data for that quarter should not display
eg suppose for 2001 oct is absent so Q4 that is dec for 2001 shoud not display.
I am using below fomula
=if(mod(Month(DATE),3) = 0, If(month(DATE) -1 = Month(Above(DATE)) and (month(DATE) -2) = Month(Above(Above(DATE))),
Above(Text)+Above(Above(Text))+ Sum(INDICATOR_VALUE)), Sum({<INDICATOR_NAME={'FRCOSTRT Index = France Housing Starts Total'},
MONTH={3,6,9,12}>}INDICATOR_VALUE)
)
and DATE is domension.
Req is to show this in bar chart
Does this resolve the issue?
=If(Mod(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)),3) = 0,
If(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -1 = Month(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE))) and
(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -2) = Month(Above(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)))),
Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)) +
Above(Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE))) +
Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)))
Output:
PFA
Hi,
in the script you can add this,
load *,
......
'Q' & ceil(num(month(Date))/3) as Quater_Month,
......
residant ......;
Hi All,
Still it is not giving desired result.Can you please suggest on this.
Thanks
Your line as below :
If any month in any of quarter is not present then data for that quarter should not display
eg in my data data for oct 2001 is absent so Q4 that is dec for 2001 shoud not display
To achieve this you can use subpress nulls
Hi,
Check the attached file. Hope this will help.
Thank you.
Hi All,
PFA.
Below is the requirement.
When data for Jan,Feb ,Mar is present then make Jan+Feb+Mar for indicator value and show data for Q1 on march.
Similirly for Q2 on jun for Apr+May+jun
Q3 on sept for jul+aug+sept
And Q4 on dec for oct+Nov+Dec
If any month in any of quarter is not present then data for that quarter should not display
eg in my data data for oct 2001 is absent so Q4 that is dec for 2001 shoud not display.
I need to show this in bar chart, but i could not find hhe solution please suggest
If any month in any of quarter is not present then data for that quarter won't be display.
What is Jan+Feb+Mar?
Jan+Feb+Mar is for Q1 need to be show Jan+Feb+Mar entire sum on Mar. if any month in respective quarter is not present then bar for that quarter should not display
All,
Can you please suggest on this.
Thanks