Need Help compare two fields

Questions & Answers
1

Hi all

I’ve a problem to compare two fields in my report
In a field I’ve a list of value, in other field the max of this children set

image

Can I compare both fields (f.e. if field1 = field2 then ok else ko)? If it’s yes how can I do?

Best Regards
Paride

2

Hi @pzecca,
Welcome to the eazyBI community! :wave:

You can use eazyBI standard calculation to get the Max value from your column (https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure)
Max.png

then you can reference it (starting with eazyBI version 6.1.) in the report specific measure (https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Reportspecificmeasures) to create other calculations using this formula to compare the data

report.png
report.png600×538 53.9 KB

best,
Gerda // support@eazyBI.com