Mar 2, 2015 · You can try to solve this by manually specifying the aggregation to be used (e.g. SUM). Thus, if your variable is called [Count C and O], you'd add SUM() to it, resulting in SUM([Count C and …

Dec 13, 2019 · You need to create a variable to determine the number that fall into each comparison category. Column Comparison=If([a] >= [b]; "A >= B"; "A < B") Then create another variable to count …

Jun 24, 2023 · Nested if statements with conditional operators in SAP WebI Asked 6 years, 7 months ago Modified 2 years, 6 months ago Viewed 11k times

Jun 28, 2022 · I have created a report in SAP BO Web Intelligence, I have input controls where users can select permission, I need to know how many rows are there in the report after choosing the …

Aug 24, 2023 · Is there a function in Business Objects Web Intelligence (Version 2010) to test if a string contains a constant? I know the MATCH() function can be used to test a string for a pattern, similar …

Dec 5, 2019 · Filter using sub report in BO SAP Web Intelligence Asked 6 years, 1 month ago Modified 2 years, 7 months ago Viewed 980 times

It's basically like in excel where you can do COUNTIF(A:A, 1) and it would give you the total number of rows where the value in A:A is 1. Is this possible to do in business objects web intelligence?

Nov 20, 2019 · Webi SAP BO Sum in block depending on two dimensions Asked 6 years, 1 month ago Modified 2 years, 7 months ago Viewed 9k times

Oct 7, 2015 · Need advice for a webi report in BO 4.1 Sorry about the alignment. I have a report as follow: Country Agent Customer Products UK Mo Sara Bag UK Adam Jill Bag UK Tim Kim Shoes UK …

Aug 16, 2021 · I figured it out, see steps below. Create a dimension variable and concatenate all the columns you like to compare into a variable. Variable name: Concat_col Variable formula: = [Col2]+ …