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.

All responses (4)

Answers (1)

Sort by

Verified answer

saurabh bharti 15,059 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Gaurangkumar Jani 4,578 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Hossam EL Hassan,

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

Thanks,
Hossam Z. EL Hassan 28 on at

Like (0)

Report
Copy link

Link copied!

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.
Suggested answer

Hossam EL Hassan 469 on at

Like (0)

Report
Copy link

Link copied!

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