Help with Set Analysis Expression...

[hopkinsc]

Hi, i am trying to write an expression to bring back total SalesValue - Total Voids for a transaction.

I know how to calculate total sales value - Sum(SalesValue), but this also includes VOID values. A void is obviously not part of the transaction value, so i need to deduct this off.

my fields are

SalesValue (the price of each item)

LineType (specifies if the transaction line is a SALE/ VOID/REFUND etc)

I have tried the following....

Sum({$<LineType ='V'>}SalesValue)

but this just displays the void value.

Can anyone help?

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Use

Sum({< LineType -= {'V'}, TransactionType = >} SalesValue)

to ignore the current selection in TransactionType.

Hope that helps

[hopkinsc]

Excellent, that worked.

Thanks very much!

[hopkinsc]

Hi, That worked to show me the result i wanted, but....

now it removes the Transaction Type selection.

So if i select a Transaction Type of 'Account Sales', the results show me all sales for the selected dates of ACCOUNT SALES. When i click on a transaction this show's me the details ogf that particular transaction but it removes 'Account Sales' from my Transaction Type selection. so when i click back i am expecting to see ACCOUNT SALES again, but instead it show's me everything.

This was working until i added the expression given earlier.

Any ideas?

Ignore the above......

It looks like the expression given earlier actually ignores the 'Transaction Type' selection completely.

I do not want that to happen. I still need to filter on 'Transaction Type' but i do not want it in the SalesValue calculation..

Is this possible?

[Miguel_Angel_Baeyens]

Hello,

If you mean you want to select all values from Transaction Type except for those that are selected (excluded values) you can do as follows

Sum({< LyneType -= {'V'}, TransactionType = E(TransactionType) >} SalesValue)

If not, please make an example of your actual data and the result is should return.

Regards.

[hopkinsc]

Hi, thanks for your reply.

I have attached a sample.

If you select 'Void' from 'Transaction Type' and '1080648' from 'Transaction Id' on the left hand side as an example You should see the following..

As you can see, the Sales Value fromn 'Transaction Header' is £2.99 (This is the total of the VOID), I want this to display the total Transaction Value instead (which is a total of the transaction details £16.50, minus voids £2.99 = £13.51 ) but i do not want the VOID selection (from Transaction Type) to be effected.

Any more help would be appreciated.

[Miguel_Angel_Baeyens]

Then, once VOID is selected,

sum({< [Transaction Type] = E([Transaction Type]) >} SalesValue)

must do. But I'm guessing that the chart should display some values regardless the selections done so I think you need to control whether the user has done any selection. Or draw two different tables.

Regards.