former_member768937
Explorer
Member since ‎2021 Sep 10

User Statistics

  • 9 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

#MULTIVALUE issue - how to get right summary with right formula

2023 Apr 03
Hello,I am trying to write the correct formula but so far I am unable to do so.My objective is to get the summary of whether contract is signed/unsigned based on the max date for each product.[Before] [After] It seems the formula in BO is n...

How to get the Max value out of 2 groupings

2022 Aug 16
Hello, I am currently having trouble in writing the correct formula for the situation below and wonder if someone could help me figure out the solution. So I have the table below as my input: My expected output is to get the latest date purchas...

How to filter period for the last3 months

2022 Jun 27
Hi experts, I have a table as per below and would like to filter the dates to only to show the last 3 months per Product. I am struggling with the proper formula and have used Rank() function but it shows 1 for all dates, which is not what I expect...

How to apply Max value to all items under each category?

2022 May 05
Hello, I am struggling with supposedly easy formula but unable to get the result I wanted. So basically I'd like to calculate the [Max Date Received] by grabbing the Max([Date Received]) based on each category and apply all those to all rows rega...

[SAP BI 4.2] How to filter excel source before merging with universe source data

2021 Sep 10
Hello, I notice that unlike universe, Webi does not have any query capability (Query Panel) for Excel source. This is especially troublesome as I would like to have filtered data before merging them with data from the universe. I wonder if there ...