Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there,
I can not get the sum of the upper arm, as seen in the picture.
I will be glad if you help me.
IF(VADE>NOW()-1,Above(Sum(BORC),0,RowNo()) ,'0' )
+
SUM(TUTAR)
+
IF( (SUM(BORC)>TOPLAMALACAK) , (Above(SUM(BORC),0,RowNo()) - TOPLAMALACAK) , '0' )
Try this:
Sum(Aggr(
If(VADE>NOW()-1,Above(Sum(BORC),0,RowNo()) ,'0' )
+
Sum(TUTAR)
+
If( (Sum(BORC)>TOPLAMALACAK) , (Above(SUM(BORC),0,RowNo()) - TOPLAMALACAK) , '0'), AP, HESAPAD, VADE))
If this doesn't work, then you will need to use Dimensionality() and/or secondaryDimensionality() functions to achieve your requirement
How to use - Dimensionality()
The second dimension... or how to use secondarydimensionality()
Try this:
Sum(Aggr(
If(VADE>NOW()-1,Above(Sum(BORC),0,RowNo()) ,'0' )
+
Sum(TUTAR)
+
If( (Sum(BORC)>TOPLAMALACAK) , (Above(SUM(BORC),0,RowNo()) - TOPLAMALACAK) , '0'), AP, HESAPAD, VADE))
If this doesn't work, then you will need to use Dimensionality() and/or secondaryDimensionality() functions to achieve your requirement
How to use - Dimensionality()
The second dimension... or how to use secondarydimensionality()
Thank you so much.