SAP IBP template TargetUoM visualization issue

[denitsa_dimitrova]

Hello, 

when i use formula SOP_TargetUoM in my template - which should Returns the value of the selected unit of measure in the current worksheet, it does not change when Target  Unit of measure is changed in the Key figure settings. 

 On the other hand the other formula - SOP_TargetCurrency - is working well, and it's returning Currentcy which is used in key Figure settings. 

Has someone faced this and if yes, do you know how to correct it.

THank you in advance!

[Andrei_Lupu]

Hi Denisa,

Check your Key Figure config (Planning Area - Model Configuration):  it must have the UOMCONVERSIONFACTOR mentioned in the "Convert Using" setting.

[denitsa_dimitrova]

Hello, thank you for the reply, but yes there is set- up ConvertionFactor in key figures, and still formula is not showing correct UoM.

[Andrei_Lupu]

It might help if you share a printscreen of the UoM formula used in the Excel template.