% needed for formula (value field) in query analyz...

former_member522325 · ‎09-23-2017

Hi all,

I have a requirement to show in percentage for keyfigure/value in my structure.

I have keyfigure A & B so combining A+B into another keyfigure called C then C value should show in % symbol.

FYI, I am getting value correct.

Please advise.

Regards

Naani

former_member522325 · ‎09-25-2017

Hi All, I am able to solve myself.

Able to get by suing %A.

My formula was C = A/B so I should get % for C .

I used as C = (A %A B).

Thank you.

Naani

former_member522325 · ‎09-25-2017

Hi All,

Can anybody advise on my query above?

Thanks in advance.

regards

Naani S

% needed for formula (value field) in query analyzer.