error:garbage after experssion :"#"

[#1]

hello team,

Good day ,

In pivot table I am facing garbage after experssion :"#" error in date field

Code :

if(aggr(($(countrylist%)),[Date]) <> 0,[Date])

how to solve garbage error?

and 

here also I am using same code in dimension but In last I am getting ' -' on date column and bellow I am seeing 0.0000%

so that last row I want hide how to hide using this --------------------- if(aggr(($(countrylist%)),[Date]) <> 0,[Date])

[swuehl]

A first step would be to fix the syntax error in your calculated dimension, but it's hard to help you without knowing the exact definition of countrylist% variable.

[sunny_talwar]

Stefan is right, it might be very easy to help if we know how you define countrylist%.

[sunny_talwar]

I think your second issue can be resolved if you select 'Suppress When Value Is Null' option on the dimension tab for your pivoted dimension (I guess it is the calculated dimension which is pivoted, so check 'Suppress When Value Is Null' option for it.)

[#5]

Okay  please check bellow Countrylist% metric how it is derived:

mcountrylist%=num(if($(mNumofCountries)<>0,(($(mNumofpeople) / $(mNumofCountries)) * 100),0),'#,##.#####')&'%'

mNumofCountries=SUM({<currentind={1>}[NumofCountries])

mNumofpeople=SUM({<livingeopleind={1>}[Numofpeople])

in second issue i want to restrict then null values or dates  in column only. don't want to do in pivot

Regards,

Bobby

[Anonymous · Accepted solution]

number format is difference

[kkkumar82]

Can you post your Calculated Dimension

[jyothish8807]

Hi,

There is an issue in set analysis. You are ,issing the closinh curly brackets near 1:

mNumofCountries=SUM({<currentind={1}>}[NumofCountries])

mNumofpeople=SUM({<livingeopleind={1}>}[Numofpeople])

Regards

KC

[kkkumar82]

mcountrylist%=num(if($(mNumofCountries)<>0,(($(mNumofpeople) / $(mNumofCountries)) * 100),0),'#,##.#####%')

Include % symbol in the num function, for clarity see the number tab for % format once