Formula in Set Analysis

[edemerdjieva]

Hello everybody,

I need to create an expression in a chart and filter the values by using a set analysis. Here is the idea:

KPI = Sum({<(Field 1 - Field 2)-={0}>} Amount) 

(exclude the values where the result of the formula is =0)

I am not sure if this is possible and what would be the syntax. 

Thanks for your help in advance.

[edemerdjieva]

@sunny_talwar

It worked 😄 !

There were two small syntax errors, so here is the final expression :

Sum({<[Voucher Code] = {"=Sum({<[Date] = {[>=$(v_DateIssue_1)<=$(v_DateIssue_2)]}>} [Voucher Issue Amount]) - Sum({<[Date] = {[>=$(v_DateIssue_1)<=$(v_DateIssue_2)]>} [Voucher Used Amount]) <> 0"}, [Date] = {">=$(v_DateIssue_1)<=$(v_DateIssue_2)"}>} [Voucher Issue Amount]) 

Thanks a lot for the explanations.

[sunny_talwar]

Super!! I am glad we were able to figure it out in the end 🙂