Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.