Removing decimal values after creating calculated item

[DandarahZ]

Hi,

After creating calculated items from date-time values, the numerical data that is displayed is accompanied by .00 decimal values. I have tried to format the data. However, that step only works in the data exploration tab and not in the report designer tab. So, how do I remove the decimal values after each of the data? Attached below is the formula that I used to create the table and the outcome after using the formula.

Regards

Dan

[FredrikE · Accepted solution]

Hi!

You change the format in the data tab in the report designer.

Select your new variable and click on "Format"

Then select how many decimals you want 🙂

//Fredrik