Calculated column used in Calculated row

(0) Share

Report

Posted on by Hossam EL Hassan

469

Hi,

I am struggling with a senario, were I have a calculated column and I want to use it in a row calculation. It is giving me wrong results if I use the default of perform row calculation first.

If I use perform column calculation first, it works but other calculated columns in the report failed.

Please guide me. Thanks.

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Can you try reference e.g. F.600 , F refers to column?

Here is how you can refer column in row calculation

docs.microsoft.com/.../advanced-formatting-options-financial-reporting

Was this reply helpful? Yes No
Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi Hossam EL Hassan,

Can you explain what exactly calculating wrong if you use Calculate Raw definition first?

Thanks,

Was this reply helpful? Yes No
Hossam Z. EL Hassan 12 on at

Like (0)

Report

Thanks for the information. I tried to apply it but I couldn't make it work.

I have another question, can we make a specific cell (row and column) with a different formatting than the row formatting.

The column is percentage, at the same time the row requires the two decimals, where as the other column are whole numbers.

Was this reply helpful? Yes No
Suggested answer

Hossam EL Hassan 469 on at

Like (0)

Report

Thanks I had to apply the changes to columns C and D then it works.

Was this reply helpful? Yes No