Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Please refer below details i need the help to count only positive value excluding 0. in total i need to need count of if can anybody help me on this.
Distributor Name | Sub Dealer Name | YTD-2024 | label_1 |
A | AA | 1 | 1 |
B | AA | -1 | 0 |
C | Bc | 2 | 2 |
D | BD | -1 | 1 |
E | SD | -1 | 1 |
F | FE | -1 | 1 |
Total | -1 | 6 |
Thanks @PrashantSangle its work fine
@stou This sounds using Sum() can help by default. Isn't it?
Hi @Anil_Babu_Samineni i did count but im getting in sum can you help me out this.
i need the count of only positive numbers.
refer the below snap. i need this type of result coloumn name is lable can you help me out.
Distributor Name | Sub Dealer Name | YTD-2024 | label_1 |
A | AA | 1 | 1 |
B | AA | -1 | |
C | Bc | 2 | 1 |
D | BD | -1 | |
E | SD | -1 | |
F | FE | -1 | |
Total | -1 | 2 |
@stou perhaps this?
Count({<[Distributor Name]={"=Sum([YTD-2024])>0"}>} [YTD-2024])
@Anil_Babu_Samineni Im facing error in it..
@stou Please always post what error it shows, Because I don't have visibility how [YTD-2024] is formed?
I tried simple expression, considering ytd-2024 is column
this expression is giving me output Sum(if([YTD-2024]>0,1))
Regards,
Prashant Sangle
@stou I could see the YTD in blue color, It means that it took as Measure label hence please share what expression used to calculate the measure.
I can see @PrashantSangle shared his thoughts, that also works (One suggestion, Instead of Sum try to use Count as you need count).
@PrashantSangle but in my case it is showing 0 not the sum of that 1.