Error: Error in expression: Sum takes 1 parameter

[agni_gold]

Hi Friends ,

I am writing below expression

(If(Dimensionality()=1 or Dimensionality()=0,

sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month>}$(vMetricBU_B_RM)),

sum({StateB<_GHQFlg=$::_GHQFlg,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month>}$(vMetricBU_B_RM))))

and variable has below expression

vMetricBU_B_RM:

=(If(Only({StateB}[KPI 22])='Total Volumes1','VOL___ORGANIC_GROWTH_RM','FIN___ORGANIC_GROWTH_RM'))

I am getting below error ,

Error: Error in expression: Sum takes 1 parameter

Please help to correct this.

Thanks

[agni_gold]

No its not working

[agni_gold]

Friends,

Any help

[Digvijay_Singh]

last try, if this works -

sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month}>}

  if([KPI 22]='Total Volumes1',VOL___ORGANIC_GROWTH_RM,FIN___ORGANIC_GROWTH_RM)))

[agni_gold]

gwassenaar‌

Any help please .

[agni_gold]

Is any other way i can approach ?

[Peter_Cammaert]

The expression you are trying to create is pretty complex and your post is lacking many of the needed contextual details. To avoid turning this into a weeklong Q&A, can you post an example document with reduced data? Then we might figure out what you intend to do and how to best accomplish this. You know, the latter may be entirely different from what you posted so far.

Best,

Peter

[agni_gold]

=sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month}>}

if([KPI 22]='Total Volumes1',VOL___ORGANIC_GROWTH_RM,FIN___ORGANIC_GROWTH_RM))

error line coming for bold