Add unit to key figure in Query Designer
in a calculated key figure I have a key figure with a unit (pc) that I want to add to another key figure that does not have a unit . The result is * of course.
I tried adding the unit to the calculated key figure, also tried a restricted key figure using the key figure without unit but the result is the same.
How can I add the unit 'pc' to my key figure to make it work?
Or even remove the unit from the other key figure as unit is not really important here?
Thanks and regards,
Use the NODIM() function on your key figure in Pcs, this removes the units. Then you can add both, or use nodim on the calculated kf.