Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
we have one table in data model with columns M2 and M5 (both numeric).
We have a formula (with set analysis conditions) that filters the data set in the table. Formula goes something like this:
=sum({$<M2={">0"}, M2={">0"}>} flagOO)
We have veryfied that we get the correct subset from the table.
In the following step we would like to make a following comparison:
M5={">=M2"}>
and sum the resulting rows (flagOO can only have numerical value of 1)
Our approach is (and it is not functioning as we expect):
=sum({$<M2={">0"}, M2={">0"}, M5={">=M2"}>} flagOO)
Can you please give us a suggestion on how we should adapt the formula? Thx!
D.
The M5>=M2 is a comparison that must be made on the row level (not globally), so you cannot use Set Analysis for that. Instead, do a
=sum({$<M2={">0"}, M5={">0"}>} If( M5>=M2, flagOfferOrder))
HIC
The M5>=M2 is a comparison that must be made on the row level (not globally), so you cannot use Set Analysis for that. Instead, do a
=sum({$<M2={">0"}, M5={">0"}>} If( M5>=M2, flagOfferOrder))
HIC
Thnks Henric!
This is the correct answer!
Best regards,
D.