Expression Help

[#1]

HI Experts

I have a targets table against each the branches

but I want to change the calculation for  one branch  in  the expression in table

ie., All Branch Daily Target is 400  but Particularly I want to change the Daily Target for branch 1017 as 1200

All Branch Monthly Target is 12000  but Particularly I want to change the Monthly Target for branch 1017 as 36000 in the Table

Please Suggest

how to write the expression for that

Please find the Sample Data attached

Desired Output

[settu_periasamy]

Try this

=if([Branch Number]='1017',1200,

Sum(AGGR([Daily Target],[Branch Number],[Branch Manager])))

=if([Branch Number]='1017',36000,

Sum(AGGR([Monthly Target],[Branch Number],[Branch Manager])))

[Kushal_Chawda]

For Daily Target

=if([Branch Number]='1017',1200, Sum([Daily Target]))

For Monthly Target

=if([Branch Number]='1017',36000, [Monthly Target])

[cspencer3]

Why are you using sum(AGGR) in your expression. Just do the sum of 'Daily Target' for the first expression and sum of 'Monthly Target' in your second. In your data the numbers are the proper number you were looking for..

[#5]

Please look at attachment

[#6]

HI All

Thank you

Apologize

I missed a point here,

the monthly & Daily targets are changing each month  for all branches

All Branch Daily Target is 400  but Particularly I want to change the Daily Target for branch 1017 as 400*3 = 1200

All Branch Monthly Target is 12000  but Particularly I want to change the Monthly Target for branch 1017 as 12000*3 = 36000 in the Table

Please Suggest

[settu_periasamy · Accepted solution]

Hi,

Create a Variable and you can give the input value as multiplier.

check the attachment may be helpful.

[#8]

HI Settu

Thanks

I will implement your suggestion in my app and Try now