on 2023 Jan 02 10:23 AM
Hello Experts,
I have two key figures KF1@TWKPRODLOCCUST and KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL.
KF1 & KF2 are separate data loads.
I want to have a calculation as if KF1 is negative number(higher level) then KF2 values (detailed level) should become NULL (only for that PROD|LOC|CUST, for remaining it should consider the KF2 data load).
As the two KF's are on different PLs, I am facing issues.
Can you please kindly help on this calculation.
Thank you.
Request clarification before answering.
Hello Bindhu
Please try this config
KF2@REQUEST = SUM("KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL")
KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL = IF(ISNULL("KF1@WKPRODLOCCUST") OR "KF1@WKPRODLOCCUST">=0,"KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL"(Stored)",NULL)
The result will look like this: (Sample illustration)
Thanks and Regards
Raghunath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.