A report that is being exported to excel has a number formatting issue.
when the value in a specific cell contains a decimal place, I need to return the value with the decimal....if the number returned in the same cell is a whole number, the export to excel does not need to have the decimal place. (The report does not show the decimal place for the whole number until exported to excel).
Currently the number formatting is #,#.#;-#,#.#.
Is there some kind of conditional statement that would eliminate the decimal if my result is a whole number
Microsoft SQL ServerSSRS
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst