Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Create a Variable and you can give the input value as multiplier.
check the attachment may be helpful.
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])))
For Daily Target
=if([Branch Number]='1017',1200, Sum([Daily Target]))
For Monthly Target
=if([Branch Number]='1017',36000, [Monthly Target])
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..
Please look at attachment
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
Hi,
Create a Variable and you can give the input value as multiplier.
check the attachment may be helpful.
HI Settu
Thanks
I will implement your suggestion in my app and Try now