I have a matrix below which is based on the G/L Account and Product when I merge the net revenue with its percentage value using
Base | G/L Weekly Revenue and Its PCT =
FORMAT( 'Calculations'[Weekly Sales], "Standard" ) & " ( " &
FORMAT([Revenue | G/L PCT], "0.00%") & " )"
How to avoid this ? many thanks in advance
>Solution :
Use an IF statement.
Base | G/L Weekly Revenue and Its PCT =
IF(
NOT(ISBLANK('Calculations'[Weekly Sales])) && NOT(ISBLANK([Revenue | G/L PCT])) ,
FORMAT( 'Calculations'[Weekly Sales], "Standard" ) & " ( " & FORMAT([Revenue | G/L PCT], "0.00%") & " )"
)

