Without Round Up we were getting the value as 6.40 in june 23 in Black (Dimension list item) after round up we are getting 8 in june 23 but the value should come as 7. This is one example we are showing here but there are multiple errors. we
are attaching the screenshot for the same
The results are different because the calculations are different.
It looks like you’re using
PREVIOUS(Month)which means the calculation of Black + June 23 is going to take Black + May 23, which are different (
Have you tried storing the integer values in one metric and then doing a
ROUNDUPin a different one? That way the
PREVIOUScalculation will happen with decimals and you’ll still have the
ROUNDUPfor either displaying / reusing values.