Need help on calculating delta values between the months

[Anonymous]

Hi All,

    In my dashboard users needs to identify delta values between two months by selecting the same. So in list boxes

i will have two set of Month Names

Ex:

Period 1: Sep 2017

Period 2 : Oct 2017

By selecting these values from two different list boxes I need to show the difference between these two months value,also I need to show it is Increased or Decreased. If it is not achievable in same object kindly let me know other workaround

For better understanding I have attached sample excel as well.

-Jai

[Shubham_Deshmukh]

At last,I think you need difference between current month count & last month count right?

If it is , then

Current month = Count(If(date_fiend>=Monthstart(today()) and date_field<=Date(Today())

Last Month = Count(If(date_field>=Addmonths(Monthstart(today()),-1) and date_field<=Addmonths(Date(Today(),-1)

And just take difference of them.

[Anonymous]

Hi ,

Thank for your response. My issue is not only finding of difference but also I need to show it is increased or decreased.

Moreover it is not between current month and previous month. User will select any of two month names from the list boxes.

-Jai

[Shubham_Deshmukh]

Ok.Means your months are in List box If yes you can try by using getfieldselections().

So that you will get selected months and you can take their difference.

[effinty2112]

Hi,

Make a list box for your monthname. Make a duplicate of it on the same sheet. Create an alternative state - Settings\ Document Properties, general tab click the button Alternate States. Call the new alternative state what ever you want say AltState.

In your second listbox's General tab you'll see the option to select the new alternative state. Now if you select in this listbox the selection in the first one will be unaffected.

If your expression for the value associated with the first listbox selection is

sum(Amount)

then

sum({AltState}Amount)

will give the value associated with selections in the second listbox, so the difference is simply:

sum(Amount) - sum({AltState}Amount)

Regards

Andrew