Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i HAVE TO APPLY THE CONDITION :
1.LOCATION= 'AB',
2.BUTTON VARIABLE CONDITION--> vDisplayButton=1
in the below expression how to apply both the conditions
=num((sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE))/IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)>999999999.99,1000000000,
IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)>999999.99,1000000,IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)>=0,1000,
IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)<(-999999999.99),1000000000,IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)<(-999999.99),1000000,
IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)<0,1000,1))))))
,'$#,###.0;($#,###.0')&
IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)>999999999.99,'B',IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)>999999.99,'M',
IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)>=0,'K',
IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)<(-999999999.99),'B)',
IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)<(-999999.99),'M)',IF(sum(GROSS_REVENUE_PROJECTED)-sum( GROSS_REVENUE)<0,'K)',0))))))