I have 3 data tables for 3 branches “Jaudat Jamuna”, “Paddo Priol”, “Bihot Bazar”
And I want to write one formula in a row for showing 3 different tables results in the same row.
Like when I select (Branch = “Jaudat Jamuna”) below formula will work
Sum(Select(Jaudat Jamuna[Sub],and([Branch]=“Jaudat Jamuna”,[Date]=[_THISROW].[Date])))
Like when I select (Branch = “Paddo Priol”) below formula will work
Sum(Select(Paddo Priol[Sub],and([Branch]=“Paddo Priol”,[Date]=[_THISROW].[Date])))
Like when I select (Branch = “Bihot Bazar”) below formula will work
Sum(Select(Bihot Bazar[Sub],and([Branch]=“Bihot Bazar”,[Date]=[_THISROW].[Date])))
How to marge those 3 formual
Please help me
Solved! Go to Solution.
I will assume that “THIS” table is a 4th table where you select the Branch name and a Date and then are shown a summed result for that Branch. I will call this summed column [Result] since I am not sure what exactly you are summing.
You will want to use an expression like below placed into the App Formula of this [Result] column:
SWITCH([Branch],
“Jaudat Jamuna”, Sum(Select(Jaudat Jamuna[Sub],and([Branch]=“Jaudat Jamuna”,[Date]=[_THISROW].[Date]))),
“Paddo Priol”, Sum(Select(Paddo Priol[Sub],and([Branch]=“Paddo Priol”,[Date]=[_THISROW].[Date]))),
“Bihot Bazar”, Sum(Select(Bihot Bazar[Sub],and([Branch]=“Bihot Bazar”,[Date]=[_THISROW].[Date]))),
0
)
The final zero (0) is a default and only assigned of the selected branch name is not know in this expression.
I will assume that “THIS” table is a 4th table where you select the Branch name and a Date and then are shown a summed result for that Branch. I will call this summed column [Result] since I am not sure what exactly you are summing.
You will want to use an expression like below placed into the App Formula of this [Result] column:
SWITCH([Branch],
“Jaudat Jamuna”, Sum(Select(Jaudat Jamuna[Sub],and([Branch]=“Jaudat Jamuna”,[Date]=[_THISROW].[Date]))),
“Paddo Priol”, Sum(Select(Paddo Priol[Sub],and([Branch]=“Paddo Priol”,[Date]=[_THISROW].[Date]))),
“Bihot Bazar”, Sum(Select(Bihot Bazar[Sub],and([Branch]=“Bihot Bazar”,[Date]=[_THISROW].[Date]))),
0
)
The final zero (0) is a default and only assigned of the selected branch name is not know in this expression.
If I want to sum more items like [Sub]+[FS Sub]+[Club]
Then how can I write the formula
Please
I don’t understand the issue.
Assuming that [Sub], [FS Sub] and [Club] are 3 comuns you want to add together, then what you have written IS the expression. [Result] =:
[Sub]+[FS Sub]+[Club]
Thanks, Thanks & Thanks
It’s Working and I learned.
This cooperation of yours prevents wasting my time in future
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |