|
クラシックファイルタイプは 2021 年 1 月をもって使用できなくなりました。クラシックファイルを移行することも、PDF をダウンロードすることもできます。詳細はこちら

Formatting Decimals

回答済み
デモをリクエスト

When preparing financials, we do not want the decimals displayed so we format the numbers to not show the decimals. When using a simple SUM formula, this does not take the decimals in consideration when they are not visible.

Example: You have 14,103.22 + 7,119.46 = 21,222.68. 

In excel with the formatting for no decimals, it displays as 14,103 + 7,119 = 21,223

But in Workiva, it displays as 14,103 + 7,119 = 21,222 (It is rounding 21,222.68 down instead of up)

Is there a ways to correct this without using round formulas?

0

コメント

1件のコメント

日付 投票
  • Mike Davis

    Hmmm.... thanks for sharing this, Brad. That does seem bizarre.

    I checked and was able to replicate IF I had "As Displayed" chosen and not "Full Precision".

    As Displayed did give me 21,222 and gave a yellow indicator it was rounding it, like so:

    Is this possibly the case for you? Let me know if I've missed the mark there or you have any questions for me.

    0

サインインしてコメントを残してください。