Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to all,
I need information, I'm making comparisons between data and I'm using the following formula:
If ((sum (Revenue) -sum (AH_TotaleFattura)> 0.01) or (sum (Revenue) -sum (AH_TotaleFattura) <- 0.01), 'Total Different', 'Total Equivalent'
The formula for it works and up to here everything ok.
The only thing I wanted to know is whether there is a possibility (perhaps via in a KPI) to show how many totals are 'different' and how many are 'equal'? I would be very comfortable and functional.
Thank you
If you have the opportunity, it might be interesting to create this formula in the script editor. So with a column of this data (like dimension in your QVD) you can simply capture them with the count command.
Script editor:
If ((sum (Revenue) -sum (AH_TotaleFattura)> 0.01) or (sum (Revenue) -sum (AH_TotaleFattura) <- 0.01), 'Total Different', 'Total Equivalent' ) as [My Formula]
Chart:
Dimension: [My Formula]
Expression: count([My Formula])
KPI:
Dimension: [My Formula]
Expression: count({<[My Formula]={'Total Equivalent'}>} [My Formula])
To calculate "how many", you'll need to define what dimension represents "many" and use that in an aggr. For example, to count how many are "different" (ie the expression is true) by Product.
Aggr(-sum(
(sum (Revenue) -sum (AH_TotaleFattura)> 0.01) or (sum (Revenue) -sum (AH_TotaleFattura) <- 0.01)
)
,Product)
-Rob