Forum Discussion

JakeSteinberg's avatar
JakeSteinberg
New Contributor III
16 hours ago

DataBuffer Aligning of Dimensions

Hello,

I have a question about aligning dimensions of a DataBuffer. I have an unallocated balance that is stored at a specific UD2 base member. This is shown in the log below:

The goal is to multiply this amount (82.1097072) by a percentage at the same Account:UD1 combination, but the rate is stored at a U2#None, not at the same U2 as the unallocated percentage:

The goal is for these data buffers to multiply and land at the specific U2# from the unallocated amount. (82.106*1.5219) However, since they are at different UD2s, they aren't going to multiply. Given that I need the specific UD2 detail, but the rates aren't stored at the specific UD2s, are there ways to manipulate the databuffer multiplication so this will occur at the detailed UD2?

Dim Buffer As DataBuffer =  RateBuffer * UnallocatedBuffer

Thank you!

 

Finance

1 Reply

  • Ruben_Moya's avatar
    Ruben_Moya
    New Contributor II
    9 hours ago

    Hello Jake,

    You can use unbalanced data buffer math functions (e.g. MultiplyUnbalanced (A#OperatingSales, A#DriverAccount:U2#Global, U2#Global)), or the not very recommended one "U2#All * U2#None" calculation script.

    Documentation about unbalanced math: Unbalanced Math Functions

    Hope this helps!