FORMAT_STRING IN MDX

shivanand-gandhari

Hi,

I created a calculated member under a dimension like below:

IIF([GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8]=0,0,(([GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8]-[GLTOT_Scenario].[OTPP].[OTPP/1].[OTPP/2])/[GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8]))

Basically, this is a percentage value. Can anyone please help me to format to percentage in the formula?

tried this but not working:

IIF([GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8]=0,0,(([GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8]-[GLTOT_Scenario].[OTPP].[OTPP/1].[OTPP/2])/[GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8])), FORMAT_STRING="Percentage";

Thanks,

Shivanand

Find more posts tagged with

Infor EPM Discussions

Comments

Matthias Englert

Hi Shivanand,

did you try something like this: format_string = '0.0%'?

Typically the same syntax like in Excel is used here.

best regards

Matthias

shivanand-gandhari

Hi Matthias,

Thanks for the quick reply. Hope you are doing good.

I tried this but not working.

IIF([GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8]=0,0,(([GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8]-[GLTOT_Scenario].[OTPP].[OTPP/1].[OTPP/2])/[GLTOT_Scenario].[OTPP].[OTPP/7].[OTPP/8])),format_string='0.0%'

Just to make clear I'm trying to create this in below section:

I would suggest setting the format in the properties of the calc - see the yellow shading - and just so the maths in the formula.

Attachment_4247.zip

shivanand-gandhari

Thanks John. It worked.

Quick Links