Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I created a straight table with 1 dimension and a measure. when i select a specific value in that particular dimension list box, that measure's exact value is shown. but when i dont make a selection, measure values are showing zeroes.
*Only for that particular measure. other different measures are working fine.
Can i get a help here please?
Hi,
Can you share your expression ?
Aurélien
num(sum({<POSITION_DATE={"06/02/2022"}, QUOTE_CCY_CD={"$(vCurrencyReport)"}>} ACCOUNT_CUR_SETTLED_AM*FX_RT)/1000000,'##,##0.0')
//vCurrencyReport is just a currency code
If you write the same expression without FX_RT, do you have a result ?
num(sum({<POSITION_DATE={"06/02/2022"}, QUOTE_CCY_CD={"$(vCurrencyReport)"}>} ACCOUNT_CUR_SETTLED_AM)/1000000,'##,##0.0')
No change. zeroes are shown.
Try with the expression without the sets, and work your way up from there.
Alternatively, try with this
IF(count(GetCurrentSelections()>0), ExpressionWhenSelectionIsMade, ExpressionWhenSelectionIsMade)
As general advice, if a measure is behaving in a irregular way, the best way to debug is to first find a concise and clear example for which you can easily determine what the correct value from the measure should be, such as selecting a specific order or account or product combined with a month, whatever is most clear. Then, strip the measure of any extras, set analysis/ifs/formatting and just pure Sum(Field). Assuming that simple measure is working correctly, i.e. there's no issue in the actual fact data in the data model, you can start adding stuff back in like the set analysis one step at the time, and see at what point you start getting issues. That should help you locate your problem and give clarity how to solve it.