Please kindly assist me in getting the expression ?

[ashmitp869]

Hi All ,

Please kindly assist me in getting the expression ?

The sample model is not working with the expression in the chart :-

JV1 Actual = $(vcmhJvPenetrationActualNew)

Please help in the below aggr function .

Not working -

$(vcmhJvPenetrationActualNew)

sum(if(
$(vCmhWbJvPenetrationTarget)>0,
Aggr(Sum(if(Bank.id=8352 and Deal.typeOfSale<>'Fleet' and Deal.jv<>'MFS',Deal.principalDebt)),Dealer.id)
))
+
sum(if(
$(vCmhMfcJvPenetrationTarget)>0,
Aggr(Sum(if(Bank.id=8356and Deal.typeOfSale<>'Fleet',Deal.principalDebt)),Dealer.id)
))
+
sum(if(
$(vCmhAbsaJvPrenetrationTarget)>0,
Aggr(Sum(if(Bank.id=8321 and Deal.typeOfSale<>'Fleet',Deal.principalDebt)),Dealer.id)
))
+
sum(if(
$(vCmhSbsaJvPenetrationTarget)>0,
Aggr(Sum(if(Bank.id=8347and Deal.typeOfSale<>'Fleet',Deal.principalDebt)),Dealer.id)
))

getting error ;

Thanks,

[prashanth1712]

I think your expression is good, it's working on my machine.

[sunny_talwar]

Second that, working for me also

Did you attach the right file?

[ashmitp869]

Please kindly send me the sample file ?

[ashmitp869]

Yes the chart is working . But when I am ticking the JV1 Actual (R) the expression is not working .

Please kindly see the image.

[ashmitp869]

Yes the chart is working . But when I am ticking the JV1 Actual (R) the expression is not working .

Please kindly see the image.

[sunny_talwar]

I think the problem is that you have Sum(If( variables.... but this variable (vCmhWbJvPenetrationTarget) is using only function.... can you elaborate as to what are you trying to get out of this?

[ashmitp869]

Hi Sunny ,

I want get the sum of Deal.Principledebt. depending on Deal.article and condition $(vCmhWbJvPenetrationTarget) all the variables should be greater that 0 then only the sum will be calculated means Sum(Deal.Principledebt) all the condtion are applied on the expression. Thanks