02-17-2022 05:30 PM - last edited on 05-23-2023 04:34 AM by JackLacava
I've been creating cube views and have sometimes found that I may forget to update a row that is part of a reporting segment. This results in the sum of the rows not equaling the total row for the reporting segment.
Does anyone have any suggestions on how I can create a row in the cube view that validates that the rows of a reporting segment equal the total row? I would want this row to be invisible and to have a condition that it would only display if there was a variance.
I'd be looking for something like this:
Row 1: $100
Row 2: $100
Row 3: Total = 200
Variance = 0
Solved! Go to Solution.
02-17-2022 06:04 PM
Hi CCI01: this can be accomplished with a calculation and simple row suppression.
That said, a few additional thoughts:
Cheers, -DB
02-17-2022 06:04 PM
Hi CCI01: this can be accomplished with a calculation and simple row suppression.
That said, a few additional thoughts:
Cheers, -DB
02-22-2022 09:47 AM
You can use a confirmation rule in a Form workflow, it forces people to validate the input before they can complete the workflow. If you're looking for an immediate reaction, you can use the save data event handler to prevent the form from saving the input (if it's not fulfilling the requirements).