Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA
As per requirement if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A,otherwise need to put Q4 data for FRQ type Q
for indicator and its respective value as per country.
but below expression is not returning perfect result
if(MinString(FRQ_TYPE)='A',Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},COUNTRY={'Singapore'},FRQ_TYPE={'A'},QUARTER={'Q4'}>}INDICATOR_VALUE),
Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},COUNTRY={'Singapore'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE))
Please suggest on this.
Thanks
Hi All,
Can you please suggest on this.
Thanks
What is the expected output?
As per requirement if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A,otherwise need to put Q4 data for FRQ type Q
seems minstring also not working.
So for any particular year, if A is available use that and if not use Q?
yes
but if Q is present use Q4
If it is not present then???
if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A,otherwise need to put Q4 data for FRQ type Q
Try simply
Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},COUNTRY={'Singapore'},FRQ_TYPE={'A','Q'},QUARTER={'Q4'}>}INDICATOR_VALUE)
still it is not working