
Contributor II
2023-05-17
11:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rounding Values for calculation
Hi all,
i need to take average 4 weeks data, need compare with one absolute number and need to show output as Increase or decrease or Equal. When i am taking average it use running numbers, and my comparing number is with single decimal point. Can anybody help me to get numbers in one decimal point to calculation.
Eg : 1) average value : 34.5643 my absolute number is 35. so it should be calculated as 34.6<35.
2) average value : 34.9643 my absolute number is 35. so it should be calculated as 35.0=35. (in this case QV calculating as 34.96 and gives output as Decrease, but my actual output should be Equal). Thanks in advance.
Regards,
Saravanan
576 Views
1 Solution
Accepted Solutions


MVP
2023-05-17
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Round(34.5643, 0.1) = 34.6
1 Reply


MVP
2023-05-17
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Round(34.5643, 0.1) = 34.6
