Is there any formula to check the previous value and the updated value in a calculated metric

Hi ​@pigment_enthusiast,

do I understand this correctly: there is a transaction list update happening which causes values to change in metrics that are driven by a formula, and you now want to use a formula to compare the old values against the new ones?

The only way I know of to use formulas to accomplish that seems to be a new feature that is being rolled out in cohorts, Restore Blocks. Since this will restore copies of your blocks, you could probably restore all your dependent transaction lists etc in a separate folder, and then use formulas to compare those restored blocks against your original ones.

Other than that, you can of course compare your data with a snapshotted scenario side by side to identify discrepancies, as long as you have scenarios enabled and a snapshot from the time that you want to compare those values to. In a View, you could make use of calculated items for the scenario dimension to calculate the difference between them.

Boolean source metric: dimensioned by G7 City , Year
Target metric is by G5 Country & Year.
SrcMetric[BY ALL: ‘G7 City’.’G5 Country’] is giving me unexpected results.

If all the boolean are true for all the cities in a specific country, then the target metric should show TRUE for that country ; Is there any way out for this?
but even if only few cities are marked as True, it’s currently giving me TRUE for that country (in target metric)

Probably, it’s getting occurred because if the source metric is either having TRUE or BLANK in all cities, → it will be resultant as TRUE in target metric.

Hi ​@pigment_enthusiast I think you are correct, the reason is that there is no FALSE, only TRUE and BLANKS, and BLANKS are ignored. To work around this issue, you could use BY COUNT and then compare to the count of countries, e.g.

SrcMetric[BY COUNT: ‘G7 City’.’G5 Country’] = 1[ADD CONSTANT: ‘G7 City’][BY COUNT: ‘G7 City’.’G5 Country’]

or work with an

IFBLANK(SrcMetric, FALSE)[BY ALL: ‘G7 City’.’G5 Country’]

but both may have a significant impact on performance, so ideally you should further limit the calculation by doing something like

IFDEFINED(

  SrcMetric[BY ANY: ‘G7 City’.’G5 Country’]),

  IFBLANK(SrcMetric, FALSE)[BY ALL: ‘G7 City’.’G5 Country’]

  )

which would ignore anything where you don’t have at least one city with an explicit FALSE or TRUE