Calculated Field

%3CLINGO-SUB%20id%3D%22lingo-sub-1279662%22%20slang%3D%22en-US%22%3ECalculated%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279662%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20find%20any%20help%20on%20this%3F%3C%2FP%3E%3CP%3EHow%20can%20I%20round%20in%20a%20calculated%20field%20using%20the%20following%20criteria%3F%20I%20need%20to%20add%20his%20in%20the%20formula%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20number%20in%20Annual%20Budget%20should%20be%20%24722%2C000.%20This%20is%20a%20pivot%20table.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22glaurie_0-1585939413955.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F181993iEA07B0DCD57A7DCC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22glaurie_0-1585939413955.png%22%20alt%3D%22glaurie_0-1585939413955.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1279662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279695%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F608477%22%20target%3D%22_blank%22%3E%40glaurie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20ROUND%20function%20in%20the%20calculated%20field%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279944%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279944%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20could%20you%20be%20more%20specific%2C%20please%3F%20I%20do%20not%20see%20a%20function%20like%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I cannot find any help on this?

How can I round in a calculated field using the following criteria? I need to add his in the formula? 

The first number in Annual Budget should be $722,000. This is a pivot table.

glaurie_0-1585939413955.png

 

 

Thanks!!!

 

2 Replies
Highlighted

@glaurie 

Use the ROUND function in the calculated field menu.

Highlighted

@Patrick2788 

Sorry, could you be more specific, please? I do not see a function like this?