Problem after adding Format function

[Lavica78]

Hi,

In our report we want to show deviation in absolute and relative values and we made the following function: 

Deviation 2018 - 2017:=switch(Deviation[Choose deviation],1,format([aps ods 2018-2017],"#,#,#,#"),2,format([% odst 2018/2017],"0.#0%"))

Problem is that formula act like it calculate nothing of nothing and returns values that it is nothing (empty lineas appears). In all categories we see all subcategories and in those that don't belong to the given category there are no values. We also have row with value "Blank".

Before function Format everything works just fine, but we must use Format function to show deviation in both absolute and relative values.

Is there any explenation and solution?

[v-jiascu-msft]

Hi @Lavica78,

Can you share a sample please? 

Best Regards,

Dale

[Lavica78]

I find solution with IF(isblank(),blank(),format())

Tnx!