Hi all,
the default format of a currency measure is ###,###,###.##, (i.e
123,456,789.00)(billion,million,thousands) in MSAS. I need the format which
is followed in Indai, i.e ##,##,##,###.## (crores,lacs,thousands,hundreds).
I tried regional settings, but the Digit grouping doesn't work.
Then I searched the net and found a solution in a newsgroup.
it is
[>9999999]##\,##\,##\,##0.00;[>99999]"##\,##\,##0.00;"##,##0.00
This works fine, but the condition >9999999 or 99999 doesn't work.
It takes the first format which is for crorres and in case amount is in lacs
places an extra comma, ie. ,57,34,536.00. I guess for conditional formating
there must be someting else available.
can neone help me here?
thanks
kshitij.