Count Function

[Anonymous]

Hi all,

I have a requirement where we need to calculate a value like  (sales/ No of months lapsed).

Ex: if we will select a year 2013 and month='July' then it should calculate the value like sales/6.

So any body can suggest how to calculate the no of months lapsed .

[anbu1984]

Sales/Num(GetFieldSelection(MonthField))

[Anonymous]

its not working...we need the number of that month selection.

By using num function its not coming.

[MK_QSL]

SUM(Sales)/NUM(Max(Month)-1)

[Anonymous]

not working

[its_anandrjs]

Try with this

Sum(Sales) / Max(Month)-1

Or if possible share the sample file.

[PrashantSangle]

Hi,

Try This,

SUM(Sales)/NUM(Max(Month))-1

Just wanted to know how you calculating Month?

Regards,

[antoniotiman]

Hi,

Your Field Month is ='July' or =7 ?

[#9]

You can try this :=sum(Sales)/(num(Month)-1).

=num(Month) will give you the int related to the month selected.

[Anonymous]

Field month is July,but i need the number 7.