Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I'm having a problem in Null values.
i'm getting total YTD correctly for all companies when disable suppressed null values.
but when i enable suppressed null values.the total getting diference.
I compared data in oracle, the individual comapny details are getting difference with QV.Here is my expression..can anyone pls help me out.how to include values
=if(vOptionCurrency=1,
(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1}>}CS_AMT_LC_1)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3}>}CS_AMT_LC_1))
+(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2}>}CS_AMT_LC_1)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4}>}CS_AMT_LC_1)),
if(vOptionCurrency=3,
(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1}>}CS_AMT_LC_3)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3}>}CS_AMT_LC_3))
+(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2}>}CS_AMT_LC_3)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4}>}CS_AMT_LC_3))))
Regards
krishna
Nulls are tricky to handle...
I recomend to check out this link in order to understand them better:
Hi Jose,
I read it.but i'm not able to understand where to apply in my expression.can u please guide me where can i apply .I'm having dimension COMP_NAME in straight table.
Regards
krishna
Hi Friends,
I'm trying to resolve the null values by using expression ..but not getting any data.
can anyone solve this isssue.
=if(vOptionCurrency=1,
(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1},CS_AMT_LC_1={'*'}>}CS_AMT_LC_1)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3},CS_AMT_LC_1={'*'}>}CS_AMT_LC_1))
+(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2},CS_AMT_LC_1{'*'}>}CS_AMT_LC_1)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4},CS_AMT_LC_1={'*'}>}CS_AMT_LC_1)),
if(vOptionCurrency=3,
(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3))
+(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3))))
Regards
Krishna