transfer slice of today mnth_str_clss to mnth_str
Hi experts,
My RPAS version 13.2.2.37
I would like to create two measures:
meas_1 -- baseint: mnth_str_clss, type: real, -db: yes
meas_2 -- baseint: str_clss, type: real, -db: display-only
When a workbook is built, I want the meas_1 slice of today is assigned to meas_2.
I tried three methods.
Method 1:
meas_2 = if(current == today, meas_1, 0)
It doesn't work, meas_2 gets unexpected values.
Method 2:
meas_2 = tssum(meas_1, today, today)
It doesn't work.
Method 3:
A middle measure is needed.
mid_meas -- baseint: mnth_str_clss, type: real, -db: display-only
mid_meas = if(current == today, meas_1, 0)
meas_2 = mid_meas.level([clnd].top)