# How to do totals?

I have a column using IIF, Could I Total that column?

I am using visual web developer to create reports for RTC.

Sum ( IIF ( (datediff( “M”, coloumn1, today()) >1), amount, 0)

It did not work? I need the sum of that amount.

Could you help me?

Barathy

Hi Barathy,

Can I first ask that you go back to the posts you have already created and let people know if their answers to your questions have worked for you? I see no replies from you, but a lot of new posts.

The code you are talking about here is not C/AL code, but code created in the new report designer, what is the DateDiff function?

Can you not write some logic to code in a running total?

t

Hi Tony

What I am doing here is :

Sum ( IIF ( (datediff( “M”, coloumn1, today()) >1), amount, 0)

1. calculating to find out the month of invoice date - today’ date

2. if the difference of the month > 1, write the amount in this coulmn.

3. it worked, and wrote the amount in this column

4. Now I need the total of this column

5. I wrote like this.

Sum ( IIF ( (datediff( “M”, coloumn1, today()) >1), amount, 0)

It gives me an error.

Could you help me?

Barathy

Hello

I found the solution for the problem.