on ‎2021 May 29 7:58 AM
How to copy a key figure values from a particular Day ?
e.g. I want to copy Key figures values of Monday only of each week to other key figures ?
Hello,
You can use PERIODID for this purpose. e.g. PERIODID for current Monday is 23107. So you can use modulus operator... something similar to below one...
IF((PERIODIDn-23107)%7=0,KF1,NULL)
Hope this will work.
- Neeraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.