Try this:

IF(TOTAL_PRICE:SUM = 0,NULL,IF(TOTAL_PRICE:SUM > 0,RowCount,TOTAL_PRICE:SUM))

Let me know if it is helpful..

Explanation:

Basic syantx for if condition is:

if(condition,true,false)

You're using if statement within if statement. so the synatx would be like this:

if(condition,true,(if criteria does not match then u are checking another if condition) if(condition),true,false)

in ur formula if you can see if the total sum is not zero then ypou are trying to return Total priuce value then you are again checking if condition which is syantatically incorrect

Try this:

IF(TOTAL_PRICE:SUM = 0,NULL,IF(TOTAL_PRICE:SUM > 0,RowCount,TOTAL_PRICE:SUM))

Explanation:

Basic syantx for an If condition is:

if(condition,true,false)

You're using an If statement within an If statement. so the synatx would be like this:

if(condition,true,(if criteria does not match then u are checking another if condition) if(condition),true,false)

in your formula, if you can see if the total sum is not zero then you are trying to return Total price value then you are again checking the If condition which is syntactically incorrect

Try this:

IF(TOTAL_PRICE:SUM = 0,NULL,IF(TOTAL_PRICE:SUM > 0,RowCount,TOTAL_PRICE:SUM))

Let me know if it is helpful..

Try this:

IF(TOTAL_PRICE:SUM = 0,NULL,IF(TOTAL_PRICE:SUM > 0,RowCount,TOTAL_PRICE:SUM))

Let me know if it is helpful..

Explanation:

Basic syantx for if condition is:

if(condition,true,false)

You're using if statement within if statement. so the synatx would be like this:

if(condition,true,(if criteria does not match then u are checking another if condition) if(condition),true,false)

in ur formula if you can see if the total sum is not zero then ypou are trying to return Total priuce value then you are again checking if condition which is syantatically incorrect