Flag creation in front end help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

Here

Column1 is calculated like below

=Round(Sum({<Type ={'Yes'}> }Amount),0.01)

Column2 is calculated like below

=Round(Sum({<Type ={'No'}> }Amount),0.01)

From these tow columns need to create a flag as

if Column1=Column2 then Match else Mismatch its created like below

=if(fabs(Round(Sum({<Type ={'Yes'}> }Amount),0.01)) = fabs(Round(Sum({<Type ={'No'}> }Amount),0.01)),'Match','MisMatch')

By this getting the result like below. its working fine

Requirement:

Now I have to create two more reports by above table as one report need to show only Match flag and one report need to show only Mismatch flags then tried like below

=if(fabs(Round(Sum({<Type ={'Yes'}> }Amount),0.01)) = fabs(Round(Sum({<Type ={'No'}> }Amount),0.01)),'Match')

here mismatch row still visible with null how to avoid that row please help me on this.

Also please could you help me how to write the expression to show only mismatch values in one report.

Note: Cant create this flag in backend all fields comings from different tables .Need to solution in front end only

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

You need to add the same condition to the two other measures. Those columns still always return a result because they don't check for a match.

=if(fabs(Round(Sum({<Type ={'Yes'}> }Amount),0.01)) = fabs(Round(Sum({<Type ={'No'}>

}Amount),0.01)),Round(Sum({<Type ={'Yes'}> }Amount),0.01))

=if(fabs(Round(Sum({<Type ={'Yes'}> }Amount),0.01)) = fabs(Round(Sum({<Type ={'No'}> }Amount),0.01)),Round(Sum({<Type ={'No'}> }Amount),0.01))

[lironbaram]

hi

you can use your flag expression as a calculated dimension

and then uncheck the show null values ,

your dimension shulod look like this

aggr(if(fabs(Round(Sum({<Type ={'Yes'}> }Amount),0.01)) = fabs(Round(Sum({<Type ={'No'}> }Amount),0.01)),'Match'),Date,ID)

and for mismatch

aggr(if(fabs(Round(Sum({<Type ={'Yes'}> }Amount),0.01)) <> fabs(Round(Sum({<Type ={'No'}> }Amount),0.01)),'MisMatch'),Date,ID)

[jonathandienst]

Uncheck the Zero Values option in the Add Ons/Data Handling properties for the chart. Or else you have more expressions that need to be handled like Column1 and Column2.

[Gysbert_Wassenaar · Accepted solution]

Disable the Include Zero values option in the Add-ons section of the properties