How to do totals?

Business Central/NAV Developers Forum
1

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

2

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

3

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

4

Hello

I found the solution for the problem.

I add CDbl function.

I add like this Sum(CDbl (IIF …),

It worked .

Barathy