@JobDeLuna - There is not VLOOKUP functions in OAC DV. You can achieve similar by creating left outer joins between the current table and one to be the VLOOUP in the dataset, then in the DV report you can filter by nulls in the VLOOKUP table to determine if the row did not have a match between the table and the VLOOKUP…

The Grand Totals follow the aggregation rule of the column values (Average Distinct) hence the total will give the average and not the sum. There is not possible to override the aggregation type just for the Totals/Grand Totals. You can enter a request at the Oracle Analytics Cloud and Server Idea Lab for having an…

@JobDeLuna - For the Base Spend 2 SUMMARY, add again the Base Spend 2 column in the visualization. Then go to the Properties view of the visualization -> Values -> select the added column and change the Aggregation Method property to Average Distinct . This will result in the desired outcome. See example below (column…

@JobDeLuna - If you want just to display the Base Plan Spend as a percentage instead of the value amount as in the report you provided, you just add the Base Plan Spend metric twice to the DV visualization, the go to Properties -> Values, chose one of Base Plan Spend column to display as Percentage and change its Display…

@JobDeLuna - Before fixing the expression to your need, just want to confirm why the need to covert the date to text. If for display format at the report, you can configure a desired display format in the visualization -> Properties -> Date / Time Format -> Format for the column. i.e. you can set the format in there as…

You can try this formula: cast(year("Snapshot Date") as CHAR(4)) || '-' || cast(month("Snapshot Date")as CHAR(2)) || '-' || cast(day("Snapshot Date")as CHAR(2))